I have created a worksheet "Materials Budget", that walks the user through the assembly process of remodeling so that the person doesn't forget to include items in the Final Estimate. Some of the row items of the Materials Budget, will not be used, so I set up a check box to highlight the row if the user will is going to use it for focus sake, and in the same row a box that indicates that the corresponding material indicated is approved for purchasing with an "x" or "y". I am using columns B:T
I am trying to create a "Final Estimate" Form that auto-populates if column Q, of the MaterialsBudget! contains text "x" or "y" (approval for purchase).
The "Final Estimate" should only include rows that meet the criteria "x or y", and should only display row contents of the ranges:
Supplies_Bathroom1
Supplies_Bathroom2
Supplies_Bedroom1
Supplies_Bedroom2
Supplies_Kitchen
Supplies_FrontPorch
End result will look like:
Bedroom-Master Supplies Chosen SKU Cost Qty Supplier Balance
(above is in Range Supplies_Bathroom1
I am also trying to create a Final Materials Order List form that will first look at MaterialsBudget! for rows where cell Q has an "x or y" (approval for purchase), then sort the MaterialsBudget! by Column R or range "Supplier", or alternatively cell contains "Home".
The result of the Final Materials List should should contain all materials to be purchased from supplier "home" as indicated in column R, in numeric order of MaterialsBudget! column "t".
End result will look like:
Description SKU Cost Qty (in order of numeric department 19-electrical, 20-plumbing, etc which is already in column T)
(above is in Range: Supplies_Bathroom1)
Can anyone help with this?
Bookmarks