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.