I am working with Excel 2016. I have a Workbook that contains a Main worksheet (where I am consolidating the data in a "pretty" format), an ERP New worksheet, an ERP Active worksheet, a 'hidden' Sheet1 worksheet (contains outside ODBC links), and a Master Worksheet that is created with my code. I found this code on this site and would like to customize it so it will only copy the visible worksheets. I want the data starting on row 5 to be copied into the Master worksheet from both the ERP New and the ERP Active worksheets. They both have the same headers, but have different numbers of rows. I want all data from A5:T5 until there is a blank row. I do not want the data from Sheet1 to be merged.
Any help would be greatly appreciated!! Thank you!
Please Login or Register to view this content.
Bookmarks