ANmarS - Portfolio - Consolid

Excel/VBA expert since Sep 1997 (19 years 10 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)

339 downloads | Last updated: 4/1/2016

Screen shots (4)