Copy row from sheet 1 to sheet 2

Aaron - Jan 21, 2015 at 05:43 AM

Please help as this is doing my head in....

I Have two worksheets, for arguments sake "sheet 1" and "Sheet 2" within my workbook, I wish to transfer a row(s) from "sheet 1" to "sheet 2" only if Column "F" contains the word "yes".

I also only want to transfer selecred columns from the row on "sheet 1", say A,B,C,F, & H etc.

These columns might not necessarily transfer to the same column on "sheet 2" as it is laid out different.

For example i am looking for......

"Sheet 1" Column 'A' to "Sheet 2" Column 'D'
"Sheet 1" Column 'D' to "Sheet 2 Column 'B'

And so on.....

Looking to make this code into a macro which is manually run by a button etc.

Please could you provide the code as i have tried making my own with snippets from forums and this has all failed.