Hi. I'm new to VBA and I'm need help to create a code for tracking a recurring task on a schedule at different frequencies.
1- I used Excel formula to generate a color value for the colors I am using.
2- Using row 5 as an example.
1- I used Excel formula to generate a color value for the colors I am using.
2- Using row 5 as an example.
- If row 5 (Area1) contains the color value "42" (blue) it should copy the cell same color, move it 31 cells to the right and paste blue color (which should be cell AG5 - I copied it manually for the example)
- I would like to the code to do this for any of the 4 colors listed for rows 5 to 9