| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create summary WB
I have a Dir with many SubDir. I want to open the file in each SubDir
which has been modified last and copy Sheet(1) to a summary WB. Rename each new sheet in the summary WB with the first 6 characters of the SubDir. In turn, close each WB, after it has been copied and the summary sheet renamed without saving it. The final result will be a summary WB with 1 sheet for each project. Your help is very much appreciated. TIA Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a summary record | Excel Discussion (Misc queries) | |||
| create a summary sheet | Excel Worksheet Functions | |||
| How to Create a Summary of Workbook | Excel Discussion (Misc queries) | |||
| Create Summary WB | Excel Programming | |||
| Create Summary Sheet | Excel Programming | |||
Threaded Mode
