Hi,
I'm trying to find a way to change the value of all cells in a column based on the number in each cell. The data will be copied into the sheet from another and for the ease of use for the end user, I want the following numbers to automatically change to the corresponding values.
01 = Acres
02 = Width
03 = Depth
04 = Sq Ft
05 = Units
It would need to work automatically once the data is copied into the sheet and without the press of a button and without adding any new rows / columns to the sheet. Is this something that can be done with code or could it be triggered to happen when data is entered into a specific cell (A1)?
I've uploaded an example and the column that would need to be changed is Column C. If anyone has any advice I would really appreciate it. Thanks in advance...
Bookmarks