Lyvonne
Sep 25, 2008, 06:23 AM
I have a workbook containing 13 worksheets. Sheet 13 contains two list tables. I need to link sheets 1 through 12 to the list tables in sheet 13 so that only one set of lists has to be updated when changes occur.
Please help me...
JBeaucaire
Sep 25, 2008, 08:34 AM
To have a cell on one sheet display the same information as a cell on another sheet, just include the sheet name in the reference.
=Sheet1!A1
=Sheet1!A2
If you change the sheetnames, change the reference to match. If you named Sheet1 Main, then the reference would be:
=Main!A1
======
STEP BY STEP
Create your main reference list on one sheet (Sheet 13?)
On the next sheet, highlight the first cell where you want the duplicate list to start and press =
Use the mouse to change sheets and click on the first cell of the reference, the formula should now look my suggestion above
Press ENTER to complete the formula
Now, highlight the first cell again where you just made your formula, then press CTRL-C to copy it
Move down to the next cell and press ENTER; your formula should cause the second item in the list to appear
Keep copying down until you have made all the items from the original reference list appear.
To create the next duplicate sheet, go to the first duplicate sheet and highlight the entire list of duplicate entries, then press CTRL-C to copy them all at once.
Switch to your new sheet and put your mouse in the position for the first item, then press ENTER
Continue ad nauseum
ScottGem
Sep 25, 2008, 08:35 AM
I suspect you want to use a VLookup to reference these tables. Checkout VLookup in Excel Help.