On the attached spreadsheet I need to populate the BOM Creator tab with the details from the TOTAL tab. The TOTAL tab contains a bill of materials for a product but I need to present the data to populate an Access database as a list of values. I need all QTY values of each AssemblyID for every PlanarID listed. If the cell is blank I do not want it to return a zero value. AssyID is just an ascending autonumber value.
The data will need to look like the following (/ indicates new column):
AssyID/PlanarID/AssemblyID/QTY
1/1/4/2
2/1/181
3/1/23/2
4/1/26/1
5/1/32/1
6/1/37/1
7/1/39/1
Any help would be greatly appreciated!!!!!!
Bookmarks