I have a VLOOKUP function that pulls data in from another spreadsheet. Every month when I need to update the data, I have to manually change the name of the source eg:
VLOOKUP(A1,'C:/Excelsourcefile - Jan07.xls'!A1:E32,2,False)
changes to
VLOOKUP(A1,'C:/Excelsourcefile - Feb07.xls'!A1:E32,2,False)
This needs to happen in many cells in many sheets.
Is there a way to point the vlookup to one cell in this workbook, that contains the file name (C:/Excelsourcefile - Jan07), so that all I need to update is that cell?
Bookmarks