Excel: Cut and paste values to an indirect cell (ref will change) after cell AB4 says "END"

Hi - Id be very grateful for any assistance with this issue - FYI, I have zero knowledge of VBA so I'm hoping for a bells and whistles piece of code that I can just cut and paste into the VBA code place!! I have 2 sheets. First Sheet is called "A". Second Sheet is called "ResA" I want to cut values from "A" and paste to "ResA". Specifically, when cell AB4 in Sheet A = "END", then I want to cut and paste the values in sheet A - A5:AG30 to the cell (indirect) referenced on sheet A - AD3 (eg ResA!A8) in sheet ResA.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of July 23, 2014.

For more resources for Microsoft Excel