Replacing a cell value by a list of items

[Skellt]

Hi, I've been lurking the forum for quite a while now, but i can't quite find the answer to this one, so hey, here's my first post

And well everything that i know in VBA is self taught so right now i'm stuck :P

To ease my explanation i've made a small excel spreadsheet. here it is;
http://1drv.ms/1dzBTUa - OneDrive link, no shenanigans - it is a zip file because stupid microsoft will open it in excel online and make my button dissapear :D

So this is only a small sample of my bigger excel spreasheet, but the idea is, that people who make quotes, only enter in the item kits, rather than entering every part #, because it's faster to do so and for a quote all the client really needs is a price, so it's just fine (the kit numbers are also much easier to remember)
But when we do actually sell the assembly and need to order the items or even take em from stock, we actually divide all the kits into their respective parts.

So essentially, i know i'm not too far off with the macro that i created but ;

• I want it to every time it finds the Brand name "Deutsch" it will insert 3 more lines below
• Copy over every part # from the Assembly page
• Multiply the quantities of each part # by the quantities in the BOM page
  • So if for instance, the Quantity of "DT06-12SA-Kit" is equal to 4, the item quantities would be :
  • 4 - DT06-12S
  • 4 - W12S
  • 24 - 114017
  • 48 - 0462-201-16141
• Every other line ; Provider ; Brand ; Description ; Cost would all copy formulas from the cell above (so the formulas would find the correct information to enter within that cell)

So yep that's it!
Any help is greatly appreciated!

Thanks

 

[Skellt]

Bump

 

[Rick Rothstein]

Bump

When I click the link you posted in your first message, I get a message saying...

"This item might not exist or is no longer available"

 

[Skellt]

No idea why, i assume OneDrive killed the link, here is a new one
http://1drv.ms/1RMqLlv