Hi. I would like to create a catalog which will house all of the possible materials that I use in doing my job….but would like a scenario where when I place an “X” in column A, all of the materials will be copied to a new sheet, which I called “BOM” in the attached workbook. I am not looking to copy the entire row though….only certain cells. On the BOM sheet is where quantities and the math to calculate selling price will go.
The cells I am trying to move to the new sheet (labels on both sheets correspond) are Part Number, Description, and List price. (respectively in columns C,D,E on the Catalog sheet).
The column labeled 'config code' will be used to filter for when a certain project has the same parts needed and is a commonly quoted project.
Once I have this working, I will be able to quickly and easily put together quotes for customers. New business due to being laid off, so I cannot afford to spend money on a larger scale solution that I know exists.
I would be truly grateful if someone can help me with this. Trying to keep my family fed.
Bookmarks