Hi All,
Losing my marbles with this now.....
. I have been trying to work out a way to filter on Data Validation. I:E On one sheet I have all my data and the separated by 5 different categories.
<tbody>
</tbody>
Then on the next sheet I will have the categories you see at the top with the data list drop down next to them. So that if I select a colour from the drop down I:E red it will only give me the red products in all the other sections to choose from. Therefore I can filter further. Now I know I can just filter on the 1st sheet. However need to do it this way for other reasons.
Hope I make sense and I hope some can help.
Losing my marbles with this now.....
. I have been trying to work out a way to filter on Data Validation. I:E On one sheet I have all my data and the separated by 5 different categories. | Cat | sub Cat | Price | Pack Size | Colour |
| A | 1 | 5 | 12 | red |
| B | 2 | 10 | 12 | blue |
| C | 3 | 7 | 45 | green |
| D | 4 | 7 | 34 | yellow |
| A | 5 | 8 | 34 | red |
| B | 6 | 10 | 45 | green |
| C | 1 | 3 | 72 | yellow |
| D | 2 | 2 | 33 | blue |
| A | 3 | 1 | 34 | red |
<tbody>
</tbody>
Then on the next sheet I will have the categories you see at the top with the data list drop down next to them. So that if I select a colour from the drop down I:E red it will only give me the red products in all the other sections to choose from. Therefore I can filter further. Now I know I can just filter on the 1st sheet. However need to do it this way for other reasons.
Hope I make sense and I hope some can help.
