Excel: compare columns in two different sheets.

HELLO GURUS, im very new to VBA macro. i have a task to be done. i have two sheets in same workbook. In each sheet i have a 20*8 matrix table with data. i need to compare column B and C from sheet1 to all the values in column B and C in sheet. for ex: sheet1 B(2,2) and C(2,3) to any rows in column B and C. if they match i need to retrieve data from column say D to H from sheet1 and place it in sheet2.

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of April 15, 2014.

For more resources for Microsoft Excel