Hi i'm looking for some help if possible?
i have a workbook where column A has a list of barcodes this amount can change (workbook1), then i have another workbook (workbook2) which has three columns with barcodes columns C, D & F in it, These relate to the barcodes in workbook1.
is it possible to have a vba code to search the first column C in workbook2 and and return what barcodes it finds then checks the #N/A's and look in the next column D and E so on until its looked through all the #N/A's
thanks in advance.
Matt
i have a workbook where column A has a list of barcodes this amount can change (workbook1), then i have another workbook (workbook2) which has three columns with barcodes columns C, D & F in it, These relate to the barcodes in workbook1.
is it possible to have a vba code to search the first column C in workbook2 and and return what barcodes it finds then checks the #N/A's and look in the next column D and E so on until its looked through all the #N/A's
thanks in advance.
Matt