vba consolidation of specific sheets data and Pasting in specific Mater sheets

Hi Team,

I want to consolidate all workbooks in master workbook.

From daily report file which has Total 14 sheets, I pick up only my teams data,
My Teams Data are in sheets (sheet1,sheet2,sheet3 sheet4 and sheet6 sheet8 ) and every sheets got name also here.
My task is pick sheet1 data Paste in Master workbooks sheet1, sheet2-sheet2 and so on.

every sheets has header here. Sometime in sheet6 and sheet8. there will not be any data. then ignore these .

Below are my code that work for…

Read the entire article at the source link… malleshg24

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

Leave a Reply