I'm about to start a huge project. I need to clean up our data from 2006-2011. I have 5 years of weekly spreadsheets with a dump of employee data.
I'm attaching 4 workbooks.
1) Is there a way to combine the books
2) Can an audit be performed and any data changed displayed? (from any column).
(for example 3552 went from status Active Pending (8/31) to Active (9/6).
EMPLOYEE is the key
I merge about 300 workbooks. Is Excel the best way to go with this?
In the 5 years, the worksheets have grown (add more data columna), data columns has changed position in the file, column titles have changed.
I thought about Access.
Is there a more powerful tool that can handle this.