Can anyone give me a macro to consolidate worksheets of different books.
workbooks from locationA.xls LocationB.xls, LocationC.xls are in one folder.
having sheets : sales, collection, advances... (sheet names unique, data
starts from row 7 in all sheets in all workbooks)
I want to have one file to show sales, collection, advance - data from each
location pasted one below the other.
I would like to have the macro in consolidation file and I would like to
keep the workbook names in sheet1 starting from column a row 3
pleeeeeeeeeeeese help me.

Hi
Take a look at the macros that Ron de Bruin has set up on his site.
http://www.rondebruin.nl/copy3.htm
That should give you a good start.

--
Regards

Roger Govier


"Eddy Stan" wrote in message
...
Can anyone give me a macro to consolidate worksheets of different
books.
workbooks from locationA.xls LocationB.xls, LocationC.xls are in one
folder.
having sheets : sales, collection, advances... (sheet names unique,
data
starts from row 7 in all sheets in all workbooks)
I want to have one file to show sales, collection, advance - data from
each
location pasted one below the other.
I would like to have the macro in consolidation file and I would like
to
keep the workbook names in sheet1 starting from column a row 3
pleeeeeeeeeeeese help me.

Wow Roger, you are great.
First I am trying to work on the examples then I will try with my live data
thanks a million. I will be back...soon
I have to merge 70 files of 8 sheets which will take a week to do accurately.

"Roger Govier" wrote:

Hi
Take a look at the macros that Ron de Bruin has set up on his site.
http://www.rondebruin.nl/copy3.htm
That should give you a good start.

--
Regards

Roger Govier


"Eddy Stan" wrote in message
...
Can anyone give me a macro to consolidate worksheets of different
books.
workbooks from locationA.xls LocationB.xls, LocationC.xls are in one
folder.
having sheets : sales, collection, advances... (sheet names unique,
data
starts from row 7 in all sheets in all workbooks)
I want to have one file to show sales, collection, advance - data from
each
location pasted one below the other.
I would like to have the macro in consolidation file and I would like
to
keep the workbook names in sheet1 starting from column a row 3
pleeeeeeeeeeeese help me.