Macro to copy array of cells

I have been stuck on this macro and hope someone can help. I need a macro that copies an array of cells into a specific set of cells. The problem is I need to match or link the cells from where it is being copied to the destination cells. For example, cell B7 copied to W12 and so on in random order. Thanks in advance any help

I presume you want to copy each cell in a continuous range (eg B7:B16) into non-continuous cells. Would it work if you copied to a continuous range, then you're non-continuous cells just referenced that new range? So you macro copies from B7:B16 to AB7:AB16, then W12 is =AB7, Z26 is =AB8 etc

Thanks for the response. Actually no, the values I am copying are not in a continuous range. Referencing the cells will not work either because of the use of the spreadsheet. It might be a long macro but I basically just need the language to say copy cell B7 to W12, copy F9 to E3, and so on.

Like this?

Please Login or Register  to view this content.