ANmarS - Portfolio - Consolid

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

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)

419 downloads | Last updated: 4/1/2016

Screen shots (4)