| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Increment linked worbook
I have a summary worksheet that has links to monthly worbooks. The formulae
look like this: ='C:\My Documents\FY05\[SEA Sep04.xls]PVUSD'!$J$27 I want to copy formulae to next column and have the monthly worbook increment. For example the formula is the next column of the summary worbook would look like: ='C:\My Documents\FY05\[SEA Oct04.xls]PVUSD'!$J$27 Can this be done. TIA Greg |
|
#2
|
|||
|
|||
|
Take a look at the InDirect function. I think this may help.
Gary "GregR" wrote: I have a summary worksheet that has links to monthly worbooks. The formulae look like this: ='C:\My Documents\FY05\[SEA Sep04.xls]PVUSD'!$J$27 I want to copy formulae to next column and have the monthly worbook increment. For example the formula is the next column of the summary worbook would look like: ='C:\My Documents\FY05\[SEA Oct04.xls]PVUSD'!$J$27 Can this be done. TIA Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| Linked worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
