Hi all,
I occasionally receive BOMs which are not condensed correctly.
I receive them in this format:
Part Number Reference Part Purchased Distributor 001 A1 2431 Dist1 002 A2 3402 Dist1 003 B1 1104 Dist1 003 B2 1104 Dist1 004 B3 F304A Dist2
However, I would like to change it to this using a macro
Part Number Reference Part Purchased Distributor 001 A1 2431 Dist1 002 A2 3402 Dist1 003 B1 B2 1104 Dist1 004 B3 F304A Dist2
Is this at all possible?
Many thanks,
Andrew Stanton
Last edited by AndyStanton; 03-23-2016 at 09:19 AM. Reason: Got columns and rows mixed up :)
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Whenever I attempt to run the macro, I get the error: 'Object Required'
Sorry but i'm new to the macro game, is it possible for a step-by-step guide on how to insert it to the file?
If you're getting that error it's likely in the right spot. CAn you post your workbook, or an example workbook with sample data that gives you the same error?
Here is my test macro-enabled workbook
https://www.dropbox.com/s/429c8hmhou...Test.xlsm?dl=1
Mixed up the loop a bit, my bad. Try:
Please Login or Register to view this content.
Hi
I had a go at this one as well. My code is a little drawn out but it's flexible in terms of where you put the table and what you name the sheet. The macro name is 'reformat_table'.
Probably allot more drawn out than it needed to be but at this stage of the night most things are. I was getting some funny errors so everything expanded out has prevented this.
Let me know how it go's.
BOMS.xlsm
Hi Danny2000,
I have tested yours and it seems to work perfectly on a full sized BOM, except for one thing- on this one, there are lots in the 'Parts Purchased' column which have the same name. Because of this, I have to run the macro multiple times to condense everything down.
Many thanks,
Andrew Stanton
Also,
apart from the issue i mentioned above, this program works perfectly! thank you!
No worries. Can I say that the logic I used was this.Originally Posted by AndyStanton
If I found a duplicate 'Part Number' the macro then checks if that previous same 'Part Number' has the same
'Part Purchased' and 'Distributor'. If these did not match between duplicate part numbers then I did not identify that as a duplicate 'Part Number'.
Having said this, I see what you mean. That complicates things a little more.
It's easily corrected if need be.
Yes, it would be nice, but not necessary.
Many thanks,
Andrew Stanton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks