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 ____________________________________________________________ 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]
