Excel duplicate data query!

  amy2690 10:19 06 Nov 06
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 06

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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant