Hi,

I need to find an excel macro that will traverse through a directory
and it's sub folders looking for workbooks (any .xls files) and
copying the first sheet named "qryExportReporting" contents starting
with column A:2 through E:2 and capturing as many rows that have text
then pasting that data into a different workbook
("AggregateTrainingData.xls") sheet called "Master" that has the same
formatting. I am a complete novice at excel and so far I've found
macros that do part of what I want but I can't get them to work
together to accomplish the whole task.


Any help is greatly appreciated!


Kelly

Hi Kelly

Start here
http://www.rondebruin.nl/copy3.htm

If you not like code maybe the add-in is a option ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Hi,

I need to find an excel macro that will traverse through a directory
and it's sub folders looking for workbooks (any .xls files) and
copying the first sheet named "qryExportReporting" contents starting
with column A:2 through E:2 and capturing as many rows that have text
then pasting that data into a different workbook
("AggregateTrainingData.xls") sheet called "Master" that has the same
formatting. I am a complete novice at excel and so far I've found
macros that do part of what I want but I can't get them to work
together to accomplish the whole task.


Any help is greatly appreciated!


Kelly