Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
previous post Increment a filename.
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment a filename | Excel Discussion (Misc queries) | |||
Expanding on a previous post | Excel Discussion (Misc queries) | |||
VBA Link - Previous post unclear | Excel Discussion (Misc queries) | |||
Correction to previous post | Excel Worksheet Functions | |||
Finding My previous post | Excel Discussion (Misc queries) |