ANmarS - Portfolio - Consolid

Excel/VBA expert since Sep 1997 (19 years 6 months)

Consolid    Added: 4/1/2016 | Created: 3/15/2016   



A quick tool to combine data from multiple tabs (sheets) into one.
This will read all tabs in a given workbook, into Sheet1 of the workbook, smart enough to not bring the headers from all tabs, only first one.

As expected, the assumptions are all tabs have exactly same columns, headers are in row 1 and Column A has no blank gaps


Download (12.8 KB)

318 downloads | Last updated: 4/1/2016


Screen shots (4)