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!
Use a formula on the second sheet. For example in Sheet2, B1 enter the formula='Sheet1'!B1and copy the formula across and down as far as needed.
This thread is now locked and can not be replied to.
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
© Copyright 2017 IDG UK. All Rights Reserved.