Copy disjoint Columns where row is determined by find operation

[aarond]

Hi,

I am looking for a code that will hopefully combine all these copy paste functions below.

The row position is matched to another worksheet, this bit works fine.

I then want to copy certain columns in this row.

Please Login or Register  to view this content.

So is there a way I can combine the Range to be copied?

Similar to if the row was fixed I could use

Please Login or Register  to view this content.

Thanks

[PCI]

Here two ways to do, the first one is more understandable

Please Login or Register  to view this content.