excel - Compare data from reference sheet using VBA, give output if variation condition met -

i working on big data, need automate process using vba in excel using vba appreciated

there 3 sheets; reference, input , output

reference sheet values fixed

jack (position a2),  5(position b2); jones (position a3) , 6(position b3); 

input sheet[input sheet values sequence may change, use vlookup comparision]

jones  (position a2) , 11 (position b2); jack (position a3)   , 4 (position b3); 

output sheet(output required if difference greater 4 between reference , input )

jones (position a2) , 11 (position b2); 

well, see it, you'll want following steps-

first how many rows have in each sheet, can snippet:

worksheets.select (1) 'this select first sheet in current workbook lastrow = range("a65000").end(xlup).row 'this return row number of last row have value <> empty in column 

do each of sheets - have upper bound loops.

next starting loop, on input sheet. can use match function find if item in input appear in referance. , it's value. check differance between them

if diff bigger four, copy whole line output, otherwise increment loop counter.

that should it.

feel free ask clearafication, english not mother tounge might bit vague.