Good afternoon!
I have been tasked with pulling a complete Materials List from a large workbook. In laying the project out it seems that I will have several thousand formulas if I try to do this without VBA. I'm not sure of the best way to replace all of these with a macro.
What I need to do is for each option, select a set of cells from the location designated by the choice and then paste them into a worksheet name "Material List". Every time the info is pasted it needs to add on to the list until I have made all of the choices. At that point the material quantities will be multiplied by a predetermined value and hopefully I end up with a sorted list of all the materials required for that set of choices. I would then pull the list of materials into a Pivot table and display only the Item, Description and Total Quantity required. I have attached a sample worksheet of with a bunch of pseudo-formulas indicating what I am trying to do. None of the "Formulas" begin with = as I don't want a bunch of errors. I'm trying to determine the most efficient way to handle this.
I very much appreciate any suggestions or thoughts regarding this project.
Thanks!
Bill
Bookmarks