Hi All,

Hope you can help here.

The situation is:

I have several Excel reports in different workbooks (only 1 workshee
per workbook) & please note the number of workbooks per iteration ca
be different, and I need to automatically collate these reports into
workbook to wrap up the process at the end.

Is there a way I can do this & make it repeatable?

Cheers
Da

--
dclay198
-----------------------------------------------------------------------
dclay1984's Profile: http://www.excelforum.com/member.php...fo&userid=3657
View this thread: http://www.excelforum.com/showthread.php?threadid=56320