Data Consolidation

Hi,

I have different workbooks, having data in multiple sheets.....
I need to consolidate multiple workbooks data into consolidated workbook (sheet to sheet)

Book1 consolidated workbook
sheet1 data sheet1
sheet2 data sheet2

Book2
sheet1 Data sheet1
sheet2 data sheet3

My request, I need to update

workbooks : same sheet data to updated in same sheet of consolidated data
Eg : sheet1 - Sheet1 (consolidated sheet)
sheet3 - sheet3 (consolidated sheet)

Please find the attachment, data to be updated to consolidated workbook.

try this code it should work........... untested............

Please Login or Register  to view this content.

If my answer helps you please add * as reputation.............