In the attached file I want to do the following;
1. create an input box
2. have the input box pass a variable ( the sheet name) into a Vlookup formula
In this case the sheet name is Feb Data, but that will change month to month
The Vlookup formula starts is cell F9 of sheet 82239 - OEM
3. have Vlookup run starting in cell F9 and filldown.
4. remove the Vlookup formula and leave its output.
Note: don't care about the totals in the file
Any help would be appreciated. Test.xls