Excel duplicate data query!

  amy2690 10:19 06 Nov 2006
Locked

Hello, I have one ms excel work book open - with 2 worksheets, named sheet 1 and sheet 2.

both sheets have exactly the same columns and headers on, how do i configure excel so that if i start entering data on the 1st sheet it automatically copies it into the 2nd?

Hope this makes sense!

  VoG II 10:31 06 Nov 2006

Use a formula on the second sheet. For example in Sheet2, B1 enter the formula

='Sheet1'!B1

and copy the formula across and down as far as needed.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

5 best 3D model websites

iPhone 8 vs iPhone X

WhatsApp : comment lire vos messages sans que l’expéditeur le sache