Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet relative reference
Hi,
I have created in a workbook a worksheet containing formulas with relative and absolute references to other worksheets in the same workbook. As I have a large number of workbooks with exactly the same structure (one workbook for each operating company), I tried to copy the worksheet with the formulas to each of the workbooks. However, the formulas in the copied worksheets have absolute references to the initial workbook. Is there any way to specify that the formulas should have relative and not absolute worksheet references? Thnak you, E.g. original formula: =IF(' Scorecard sales orders'!$B62="";... copied formula: =IF('[EBM_O2C_Scorecard_ES.xls] Scorecard sales orders'!$B62="";... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative worksheet reference clarified | Excel Discussion (Misc queries) | |||
Relative worksheet reference for multiple worksheets in a workbook | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Relative Reference | Excel Discussion (Misc queries) | |||
Relative worksheet reference in 3-D formulas? | Excel Worksheet Functions |