this is a soultion for a self encounterd issue , i posted so that if someone has the same issue they could use it . this program selects a row in excel workbook then compares it to another excel workbook and paste the row next to it isnide the other excel workbook.
we using this code please put your sheets in the location of mine then alter the direction to your sheets.