I am trying to create a spreadsheet for lab analysis for products our company produces.
I want to create two separate rows with drop down menus. One drop down list will be the requirements for the product and the other will be the results of the lab analysis.
I want to be able to correspond one drop down list with sheet 2 and the other list with another sheet since I will need to add lab results on a weekly basis.
I'm looking to create something similar to thisblank BOL.xlsx. I have looked through plenty of threads here and did not understand any of the other explanations. I know VERY little about excel, it would be best to explain it to me as if I'm using it for the first time.
BTW, I'm using Excel 2010 if it makes a difference.