Select values
Hello, thanks in advance for any help that can be provided.
I own a business that builds custom motorcycles. I have an Excel spreadsheet that I use to keep track of the build and budget. Next to every item is a price. Every build is different so I don't use every line item in every build. I would like to be able to check a box next to the items that I am using which would then move the price over to the next column which is the one that gets added up for the build total. Is this possible and how can I make it happen?
I am using Excel 2010
Thank you,
Roland
Select values
Hi Roland,
I think I get what you're after...however, there might be a more user-friendly way to do this. Let's see if I can explain...
On Sheet2 of your workbook, create your complete build list so that in column A you have your entire build list and in column B you have the relevant price.
On sheet1 in cell A1, you will create a data validation drop-down list based on your build list on sheet2.
This will allow you to select the part you require using the data validation list. Once you have created the drop-down list using you will be able to copy it down however many rows you want in column A.
All that is required now is a VLOOKUP formula in column B on sheet1 which will automatic display the price relevant to the part you select.
If you would like me to create a sample sheet to send to you, let me know.
AP