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...
![]() |
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...
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
I suspect you want to use a VLookup to reference these tables. Checkout VLookup in Excel Help.
All times are GMT -7. The time now is 02:21 PM. |