Hello!
Need your help guys. Just wondering if this is possible (see bom1 and bom2 screen shots)
Basically what needs to be done is:
Detect material change in column F, add 2 empty rows between different materials, add WEIGHT: and do weight sum in Column G..... and so on for the entire spreadsheet.
At the very end need to See entire WEIGHT for all parts.
Any ideas? Thanks in advance!
Alex.
Does it need to be in that format? If you add a column for total weight for each type of material, it would be easy to do this with just formulas. If you really need this format with rows inserted then a macro will probably be easier. It would have to be set up to run anytime the worksheet changed.
Also, please see my editorial about screenshots below...
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Re: Editing BOM automatically
Thanks,
Please take a look at the original spread sheet that Inventor spits out, I`m using macros (Ctrl+shift+F) to change it a little bit. Then if you run the macro below it will add 2 rows between materials...
My question is how to add WEIGHT: in F column and sum weight in G column???
Please Login or Register to view this content.
Last edited by achmidt; 11-16-2011 at 03:26 PM.
Please Login or Register to view this content.
Re: Editing BOM automatically
Great ! Thank you.
The other question I had, how to format cells (add borders) using vba? I guess I need to detect the lowest right corner.... how I can do that? For this particular document it is 132, but all documents are different lengths.
After downloading document please goto macros and run WEIGHTLIST1
Please Login or Register to view this content.
Instead of
you can use:Please Login or Register to view this content.
But if adding a simple column:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by snb; 11-17-2011 at 05:42 PM.
Thanks snb, it does works faster now.Originally Posted by snb
Instead of
you can use:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks