using a file name in a cell

[k_babb]

i was wondering if it was possible to use a cell for a filename

i have a report that i call off every month and i need some information in my current speadsheet so i would have a cell like='C:\Users\K.M.Babb\Desktop\lnvoices\[InvoiceEndSep.xlsx]New Text Document'!$A$2 is it possible to replace the invoiceendsep with a cell like a1 and then i could just change cell a1 next month to invoiceendOct and thus update the whole spreadsheet to look at Octobers values

thanks for any advice

 

[Smitty]

You could use INDIRECT.EXT, which is part of the MOREFUNC add-in, but it does carry performace issues with a lot of formulas.

Or you can use Find & Replace to update the formulas. You can also use Edit-->Links and point the new month to the right place.

HTH,