code to automatically change value of a cell from a number to a specific word

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...

It can be done automatically but I would be cautious about it's implementation. It would be better if you have a specific cell that you enter a final number into (like a date) you could use to trigger the macro to run at that time. I have attached the macro which will work when you paste data into the sheet, or do anything else in the sheet for that matter:

Please Login or Register  to view this content.

Originally Posted by stnkynts

It can be done automatically but I would be cautious about it's implementation. It would be better if you have a specific cell that you enter a final number into (like a date) you could use to trigger the macro to run at that time. I have attached the macro which will work when you paste data into the sheet, or do anything else in the sheet for that matter:

Please Login or Register  to view this content.

This works perfectly. Thanks, stnkynts!