Cross Referencing between worksheets
OK. Help please.
worksheet one contains hundreds of rows of information. Worksheets 2-5 have many formula cross references to this first worksheet to pull information from a selected row. How do I identity to the other worksheets which row to take the information from. IE A formula on worksheet two might be "='Letter Info'!L1" ... however I need to vary the line from L1 to maybe L2 or L3 or L4. Apart from changing manually as this occurs for many columns , how do I make reference to which row to take the information from ?? Any help greatly appreciated. |
Cross Referencing between worksheets
If you look at your cross reference formula the cell address in the look
something like this: $A$1 Just remove the $ from the cell reference to make the cell relative and then copy it down a column or across a row. The $ indicates an absolute reference that does not change when copied. Cells can be addressed in the following manner: A1 = Relative cell where both column and row adjust when copied A$1 = Relative column, absolute row $A1 = Absolute column, relative row $A$1 = Absolute column, absolute row -- Kevin Backmann "David Brereton" wrote: OK. Help please. worksheet one contains hundreds of rows of information. Worksheets 2-5 have many formula cross references to this first worksheet to pull information from a selected row. How do I identity to the other worksheets which row to take the information from. IE A formula on worksheet two might be "='Letter Info'!L1" ... however I need to vary the line from L1 to maybe L2 or L3 or L4. Apart from changing manually as this occurs for many columns , how do I make reference to which row to take the information from ?? Any help greatly appreciated. |
All times are GMT +1. The time now is 02:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com