Hello,
I've been working on this macro and can't seem to get it to work.
What I need it to do is this:
1. Start by Copying Cell A2 in Worksheet "CP Report Pull"
2. Then paste the copied A2 in to cell K2 (Circled in Green) on Worksheet "Week View" (Also Circled in Green)
3. After pasting in to K2, copy cell K14 (Circled in Red)
4. Paste the copied K14 value in to cell A2 (Circled in Green) on Worksheet "Sheet2"(Also Circled in Green)
*5. I need this Macro to be able to repeat itself. For example, after it is done doing A2, it will repeat the above process for A3 in Worksheet "CP Report Pull" and know to paste in cell A3 on Worksheet "Sheet2" and so on.*
As of right now this is the macro that executes the initial action for cell A2.
Can somebody help me?
I've been working on this macro and can't seem to get it to work.
What I need it to do is this:
1. Start by Copying Cell A2 in Worksheet "CP Report Pull"
2. Then paste the copied A2 in to cell K2 (Circled in Green) on Worksheet "Week View" (Also Circled in Green)
3. After pasting in to K2, copy cell K14 (Circled in Red)
4. Paste the copied K14 value in to cell A2 (Circled in Green) on Worksheet "Sheet2"(Also Circled in Green)
*5. I need this Macro to be able to repeat itself. For example, after it is done doing A2, it will repeat the above process for A3 in Worksheet "CP Report Pull" and know to paste in cell A3 on Worksheet "Sheet2" and so on.*
As of right now this is the macro that executes the initial action for cell A2.
Can somebody help me?