Automatic updating of 2nd sheet from first
I have a list of products in sheet 1 which i need to copy into sheet 2. I need sheet 2 to automatically update any changes i make to sheet one, can anyone help please? -- fibregrid ------------------------------------------------------------------------ fibregrid's Profile: http://www.excelforum.com/member.php...o&userid=25707 View this thread: http://www.excelforum.com/showthread...hreadid=391236 |
Good morning Fibregrid Why not set up an array formula. You will have to define a range first, so say your products are going to be in range A1:H100. Select this range on your destination sheet (say, Sheet 2) and press “=”, then go to your source sheet (Sheet 1) and select an identically sized range. Then to commit the formula press Ctrl + Shift + Enter. Then anytime anything is entered within the set range on Sheet 1, this will be replicated on Sheet 2. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=391236 |
Hi Dominic, It Worked!! Thank you very much Sonya (Fibregrid) -- fibregrid ------------------------------------------------------------------------ fibregrid's Profile: http://www.excelforum.com/member.php...o&userid=25707 View this thread: http://www.excelforum.com/showthread...hreadid=391236 |
Hi Sonya Certainly did! You're welcome - thanks for the feedback. DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=391236 |
All times are GMT +1. The time now is 07:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com