Hi everybody I have a bunch of files with the dates in this format 20130321.xls going back to 2008. Each file contains a few hundred names and a corresponding number. I want to consolidate all the numbers with each name in a master file.
For example, Steve on 3/21 was 15, 3/20 was 32 etc.
in this Master sheet I want it to say
a b
1 steve
2 3/21 15
3 3/20 32
.
.
.
I am using Excel 2010 on windows 7 64 so I can't use indirect.ext
I can only think of 2 solutions, manually edit the vlookup formula in column b for each date
or open every file and use indirect and hope that excel doesn't crash.
Is there another option I am missing? Thanks
Bookmarks