I have an excel estimate sheet I made for doing comstruction estimates. My idea is to make drop down lists in the estimate sheet for products needed for the job. Each line item will have a drop down list of the supplies/materials to choose from. I want to take supplies/materials that were chosen from the drop downs and add them to another sheet, supplies/materials sheet. The part I’m not sure how to do, is getting the selected items from each drop down list and putting it into another sheet, and then being able to use that sheet to show all the materials and supplies needed for the job. Any help would be greatly appreciated. Thank you.

​I have an excel estimate sheet I made for doing comstruction estimates. My idea is to make drop down lists in the estimate sheet for products needed for the job. Each line item will have a drop down list of the supplies/materials to choose from. I want to take supplies/materials that were chosen from the drop downs and add them to another sheet, supplies/materials sheet. The part I’m not sure how to do, is getting the selected items from each drop down list and putting it into another sheet, and then being able to use that sheet to show all the materials and supplies needed for the job. Any help would be greatly appreciated. Thank you.  Read More

​