Changing set range to a variable range in macros

I recorded a macro in which I selected a range to paste values. The issue is that I need the macro to paste the values in a different column depending on a given set of criteria.
The criteria is as follows:[INDENT]For each set of data I have created a cell that tells me the desired location (row # and column letter) of the values[INDENT]I need the macro to look at those cells and from them know where to paste the values I selected.

Here is my current macro:

Please Login or Register  to view this content.

I feel like I am close but have been unable to run the macro without errors. Any help would be greatly appreciated.

You are actually very close!

If D2 contains the text Z100 and C2 contains the text Z101, the you want:

Please Login or Register  to view this content.