I am creating a macro to help with daily tasks. I have gotten to the point where my data is in two columns (
A,B) and column A has the data colored both yellow and green and then sorted to where the yellow data is first.
What I was wondering is if it is possible to auto fill the cells in the column C according to the color of the corresponding cell in column A.
So any cell that is yellow in column A, for example A2 is yellow, I need C2 to say RV. But if it were to be green I would need C2 to say NC.
I am able to get it to do this for one single cell, but what I need is for it to check every cell in column A and then auto fill all the cells in column C.
Hopefully I have been clear enough and this is possible!
Thank you in advance guys
A,B) and column A has the data colored both yellow and green and then sorted to where the yellow data is first.
What I was wondering is if it is possible to auto fill the cells in the column C according to the color of the corresponding cell in column A.
So any cell that is yellow in column A, for example A2 is yellow, I need C2 to say RV. But if it were to be green I would need C2 to say NC.
I am able to get it to do this for one single cell, but what I need is for it to check every cell in column A and then auto fill all the cells in column C.
Hopefully I have been clear enough and this is possible!
Thank you in advance guys
