ExcelBanter - Increment linked worbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Increment linked worbook (https://www.excelbanter.com/excel-discussion-misc-queries/3297-increment-linked-worbook.html)

GregR

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

Gary Brown

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

All times are GMT +1. The time now is 09:54 AM.