I have two worksheets with various fields.

The common numeric field is ID in both sheets.

I want a IF for VBA.. when If ID in Cell A1 ins within sheet 2. range C:C
copy that row from sheet 2... nad paste in Sheet 1.. in cell A1.

then go to next record and repeat...

The idea is to merge both sheets into 1 with al lthe fields...

Is it possible?