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? |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com