KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
I was wondering,
Is it possible within a Data Validation List, if you select an option in the top cell, for it to change the entire column to that option?
Example:
Say you have fruits in the list in column A:
Apples
Kiwis
Watermelon
But it goes down 100 Rows.
Is it possible to Change Apples to Kiwis in Column A2 and have it change ALL apples to kiwis going down (A3-A100)?
Is it possible within a Data Validation List, if you select an option in the top cell, for it to change the entire column to that option?
Example:
Say you have fruits in the list in column A:
Apples
Kiwis
Watermelon
But it goes down 100 Rows.
Is it possible to Change Apples to Kiwis in Column A2 and have it change ALL apples to kiwis going down (A3-A100)?