Feb 16 2022 08:50 AM
I have been looking around and can not seem to find the exact thing I need.
So I have a sheet I use to estimate roofing with. I got a list of products with prices and quantities.
My goal is to get a material list created out of the sheet I do all my pricing with.
My main sheet
I want the number from the quantity cell and the description cell to transfer over to another sheet on the same workbook. Below is the other sheet on the other workbook.
On my main list, I want the cell that has a quantity to transfer over to my material list but in the top to bottom order.
Ex:
The main sheet has:
30 TPO 10'x 100'
40 6' x 100'
20 4' x100
15 1/4" dendeck
15 1/4" dendeck prime
My material list will reflect the quantity of material with the same name on the main sheet.
My main list has about 145 entries.
I have been messing with an IF formula but can seem to get it right. I would appreciate some guidance in the right direction.
Feb 16 2022 10:59 AM
Feb 16 2022 11:39 AM
Thank you, I will start attempting this route. I will update once completed.