Excel duplicate data query!

  amy2690 10:19 06 Nov 2006

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


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