Excel duplicate data query!

  amy2690 10:19 06 Nov 06

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


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…