Hey all,
Have tried to google and seach with out any succes.
My question is as follows:
I have created a dropdown list with data validation. The list has products on it shuch as: "Solar Freedom S10". The dropdown list is in sheet 1 and the data to validate in another sheet(4).
Now i also created a dependent data validation for a second list so users can only choose one option (a price) after choosing a option in list number one(which is a product).
I followed the tutorial on: http://www.contextures.com/xlDataVal02.html#TwoWord
To be able to create the data validation dropdown list, the name from my range(one cell i my case) should be exactly the same as the matching entry. This i can't because in my case these are numbers,... € 4,112.23 te be exact...
The tutorial says:
"2. Create the supporting Named Lists
Type the entries you want to see in the Excel data validation drop-down list for one of the Product categories.
Select the cells in the list.
Click in the Name box, to the left of the formula bar
Type a one-word name for the list, e.g. Fruit. This name must be exactly the same as the matching entry in the Produce list.
Press the Enter key."
You can see my excel file included.
What i want to achive is whenever a user selects a option (product) in list 1: The variables of the following lists are depenent on it. It would even be better that if the product is selected the following cells are filled with some information which is on a second tab(the all are prices).
Any suggestions?
Bookmarks