Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.
Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis with a pivot table. The problem is that not all sites will have the same applicable data, so I made a master spreadsheet with all fields tailoring each sites to the master sheet's columns to simplify merging - I blocked non-applicable columns.
MS Access 2000 and Excel 2010
December 1, 2010 2:52 PM
December 7, 2010 6:41 PM