Hi All,

I was hoping someone here already has some script to help me achieve the following;

1. From within a specified folder (containing many Excel workbooks) open one w/b at a time
2. Copy a named range (from the file opened via this script) and "append" it to the last blank row in a (RawData) sheet in a master file that collects the data from all the files in the specified folder
3. Rename the sheet (from the file opened via this script) to a value from a cell (let's say "A1") in the sheet
4. Copy the sheet to the master file (at the end)
5. Close the file opened via script
6. Move it to a separate (Completed) folder
7. Open next file from specified folder
8. Repeat from step 2 above

Much thanks for any and all help in this regard. I know a bit of VBA, but not enough to complete this exercise.

Later,

C