Tigerstyler
Board Regular
- Joined
- Mar 17, 2003
- Messages
- 53
Hi,
I have a drop-down box in cell B6, giving the user two data validated options, "X-DOCK" or "STOCK".
If "STOCK" is selected, I would like to clear the contents of cells B4 and B5 (B4 and B5 are also data validated drop-down boxes working from lists).
I have tried adding changing the formula of the list, so that when "STOCK" is selected, the list entries go blank. However, the drop-down selections in B4 and B5 stay on the same selection unless manually refreshed.
Any ideas?!
Many thanks
I have a drop-down box in cell B6, giving the user two data validated options, "X-DOCK" or "STOCK".
If "STOCK" is selected, I would like to clear the contents of cells B4 and B5 (B4 and B5 are also data validated drop-down boxes working from lists).
I have tried adding changing the formula of the list, so that when "STOCK" is selected, the list entries go blank. However, the drop-down selections in B4 and B5 stay on the same selection unless manually refreshed.
Any ideas?!
Many thanks