Automatically Combining Sheets
 

Hello the floor.

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

Any help would be very appreciated.

Regards,
Andy


--
andyiain
------------------------------------------------------------------------
andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335
View this thread: http://www.excelforum.com/showthread...hreadid=534602

Automatically Combining Sheets
 

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

"andyiain" wrote:


Hello the floor.

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

Any help would be very appreciated.

Regards,
Andy


--
andyiain
------------------------------------------------------------------------
andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335
View this thread: http://www.excelforum.com/showthread...hreadid=534602