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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…