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

#codango #developer #development #coder #coding

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

Your email address will not be published. Required fields are marked *

*