Excel amateur here... I work for a new home builder and I am looking to create a material selection spreadsheet that ends up automatically creating a building cost/price. My goal is to have separate lists for each finish/fixture that would be selected in a home build (faucets, trim, doors, windows, siding, etc.). So each of these would have their own list with the various styles of faucets, trim, doors, windows, siding, etc. that are available. I want each item in the list to be assigned a dollar value, so when the item within each list is selected, it puts the dollar value assigned to that specific item in a separate worksheet that contains all the pricing for the home build. I hope this makes sense! If any further clarification is needed, please let me know! I went on Excel help chat and they referred me here saying macros would be required (I've never used a macro...).
Thanks in advance!
Justin
