G
Guest
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.
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.