Automatically Combining Sheets

A

andyiain

Hello the floor.

I have dozens of folders each with dozens of files in them. All o
these files hold equivalent data, it is just one week per file. I
there a non-manual method of putting all of the files in one folder i
to one file. I have been copying and pasting the data but it'
inefficient and I am getting RSI, going crazy and lost the will to liv
sometime back in the long hot summer of '04.

Any help would be very appreciated.

Regards,
And
 
E

Emma Hope

Andy,

Not an expert but there is a thingy called 'Merge Workbooks' on the Tools
Menu which i use to do something similar. Have a look at the help on it, if
it doesn't seem straightfoward but i hope this helps.

Regards
Emma
 
Top