Hi,
I have a folder with lots of excel files in it.
What I want is a vba code that will
>>Collate Data Button
1. First create all the sheets as per the file names , based on the path name provided on "B5" of "Check Load" Sheet.
If already contained, Then Delete all the sheets and recollate it.
For example: I have 8 files now in the "C:\Testing P2" folder , So there are 8 sheets in the file.
2. Copy all the "Sheet 3" Called "Load Results" from the files present in the folder to the respective sheets.
>>View Results Button
1. Bring in and show all the results from all the sheets as per date on cell "B9" on "B12 to H12".
Thanks in advance,
Me
Bookmarks