Macro Help Copy&Paste Rows

[Leoparddd]

Good morning,

Could you guys please help me out with a macro:

--This will retrieve both found and #N/A results

*Step 1: In Column F do a Vlookup funtion using Column A from Sheet1 as Lookup_Value and Column A & B from Sheet2 as Table_array, Col_index_num "2" to return Column "B" value (like =VLOOKUP(A:A,Sheet2!A:B,2,0))

*Step 2: In Column G just multiply Column F with Column C (like =C1*F1)

*Step 3: Select all rows with data found in cells F & G and copy&paste them into "Sheet4". (This is tricky for me)

Please find attached: Example.xlsx

Thanks in advance!!!

[Leoparddd]

Hi, or maybe just a sample code to do this: If data found in Column, copy entire rows and paste them in another worksheet. I think I can figure out the rest... thanks