Ge wrote:
Paul Gaastra wrote:
Sounds like the right way to do it but I'm not an Excel expert.
I may do a LabVIEW program to do it.
What you want in Excel is a pivot table. Simplified: Import the one BOM in
one sheet, the other BOM in another sheet. Copy the data of both into a
third sheet, so that they form a single area. Make sure the columns have
proper headings. Then create a pivot table of that area in yet another
sheet (using the pivot table wizard).
Now experiment a bit with the pivot table and the fields in it; probably
doesn't take long until you "get it". Possibly a pivot table tutorial
beforehand helps. Much quicker than any programming.
Gerhard
At risk of sounding lazy do you have an example xls file of the finctionality
that you are able to extract with using the pivot table. Always avoided pivots
for some reason, perhaps the lack of an application...
I see what you mean on the qty field, anything else of interest?
--
Cheers
Don
____________________________________________________________
You are subscribed to the PEDA discussion forum
To Post messages:
mailto:[email protected]
Unsubscribe and Other Options:
http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004):
http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current):
http://www.mail-archive.com/[email protected]
