rickbisselink
Board Regular
- Joined
- Oct 16, 2007
- Messages
- 146
Hi all,
Could not find the solution elsewhere that combines my following questions, so I hope one of you has the solution!
I am trying to dependent validation list, where the source data is in one table (A1:C14). The table headers are generic and so cannot be used to refer to for the second validation list. The values in each of the columns in the table are not unique, so the validation lists need to have distinct values. Please find below my (test) worksheet, the validations would go into cells E2, F2 and G2, where F2 is dependent on E2 and F2 is dependent on E2 and F2.
Hope I'm making myself clear, thanks for your responses!
Kind regards,
Rick
Could not find the solution elsewhere that combines my following questions, so I hope one of you has the solution!
I am trying to dependent validation list, where the source data is in one table (A1:C14). The table headers are generic and so cannot be used to refer to for the second validation list. The values in each of the columns in the table are not unique, so the validation lists need to have distinct values. Please find below my (test) worksheet, the validations would go into cells E2, F2 and G2, where F2 is dependent on E2 and F2 is dependent on E2 and F2.
Hope I'm making myself clear, thanks for your responses!
Kind regards,
Rick
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Day | Name | Product | Day | Name | Product | |||
| 2 | Monday | John | Apple | ||||||
| 3 | Monday | John | Pear | ||||||
| 4 | Monday | Peter | Orange | ||||||
| 5 | Monday | Peter | Banana | ||||||
| 6 | Monday | Steve | Kiwi | ||||||
| 7 | Tuesday | Karen | Orange | ||||||
| 8 | Tuesday | David | Mango | ||||||
| 9 | Tuesday | Jane | Tomato | ||||||
| 10 | Wednesday | Peter | Strawberry | ||||||
| 11 | Wednesday | Ryan | Kiwi | ||||||
| 12 | Wednesday | Karen | Lemon | ||||||
| 13 | Wednesday | Anne | Raspberry | ||||||
| 14 | Wednesday | Tom | Lemon | ||||||
Sheet1 | |||||||||
