Increment linked worbook

  • Thread starter Thread starter GregR
  • Start date Start date
G

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a list of worksheet names (from a single folder, or open files) 2
Problem with linked workbook 1
Increment value in a Formula 7
Linked Cells, Increment Sheet Number Ref. 3
Increment a filename 4
Help with Linking to new documents 5
Increasing date in link 7
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top