This is from a 2007 post, posting again in hopes of getting more information...


I found this very interesting, as I did not think it possible. I copy and
edit links daily to change the file name. I was not able to figure out how
to make this formula work. I would really appreciate your assistance.
My example is:
='\\Algfilesrv\users\Accounts Receivable\SHARE\09-10 FY\MISC\[AR Backlog
Report - JULY 10, 2009.xls]AR Backlog Report'!$D$45

The only thing that changes is the date
='\\Algfilesrv\users\Accounts Receivable\SHARE\09-10 FY\MISC\[AR Backlog
Report - JULY 11, 2009.xls]AR Backlog Report'!$D$45.

I also have one that the tab name changes
=JUL10!C$86
=JUL11!C$86
Please advise.


"Gary''s Student" wrote:

Something like:

=INDIRECT("'C:\[Book" & ROW() & ".xls]Sheet1'!$C$20") in row 1 will pickup
Book1
in row 2 will pickup Book2, etc. This is a method to increment either a
filename or directory name as you copy down the column.
--
Gary''s Student - gsnu200722
Was this post helpful to you?