Total VB novice coming in here. First time I've ever used it.
I'm trying to create a tool for my company that will help sales create equipment lists with prices, part numbers, quantities. I've managed to accomplish something close to what i want using a button on. Which then extracts any Row in the product table with a value >=1 in the quantity section.
However, the problem I am facing now is that every time I press the button on the manufacturer page to deploy the Macro and extract the data it will add the same units again, essentially duplicating the rows. I'm sure there is a way to prevent this but I can't figure it out with my basic VB knowledge.
Some guidance on how to correctly do this would be super helpful! I've attached a sample work book which is clear.
Thanks,
Bookmarks