Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic changing refrences to sheet corresponding to first day. | Excel Discussion (Misc queries) | |||
Sheet not updating | Excel Discussion (Misc queries) | |||
automatic new serial number for each new sheet within one file | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |