Sort and tally bill of materials

Hi,

I need help with a macro to sort and tally components listed in a bill of material for a printed circuit board. On the attached workbook, in columns A:F is the bill of materials as output by the schematic capture software.

Unfortunately, this format is difficult to use for ordering components. An example of the format that I need is shown in columns I:O. Basically, the reference designators of all components with the same part value are placed in a single cell as shown cells I7 and I8. An additional column, column O tallies the number of components with the same part value.

Columns J:N would simply copy the component information from columns B;F.

I could probably do this manually , however, I need to ensure correct quantities are ordered. This is a small bill of materials. I have several others for which I need to do the same that have over a hundred components.

Can anyone in the Forum help with a macro that can sort and tally as described above?

Thanks,

Art

this looks like it works....it's a little more funky than I prefer but it works for small files....

I just take the partnumbers and use remove duplicate function in XL and use that list to loop through and collect data....

I suppose technically you don't have to clear each variable in the loop, but I do it because I get to choose what it is, instead of XL potentially choosing something weird...

Please Login or Register  to view this content.

Hi Art;

Thanks for setting the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be one of us...just a thought...and have a great day