Increment linked worbook

[GregR]

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