Does anyone have an example of using a variable file name (and tab) in a vLookup? I have many files with many vLookups that have to be changed every month. It would be wonderful if I could only key the variable name once instead of copying and pasting so many vLookups. I've tried a number of different ways to accomplish this but have been unsuccessful. Please, if anyone has an example that works?
and build the a cell up and them point the INDIRECT to it and it should work
Last edited by myle; 12-04-12 at 03:47.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE