hello

I have a file Book1.xls which has the following data

Bardcode Quantity
100 1
102 3
105 2
167 1
178 3
189 1
250 6
345 3
356 2
478 1
678 3
679 1
755 6



and there is another file named Book2.xls which contains

2
4
5
7
9
11
12
13

the task is to find out the barcodes for the Row number mentioned in Book2.xls.
Using normal excel formula, i would paste the Col A of Book2.xls in Col F of Book1.xls, delete the header row. then i would calculate the row using =ROW() and paste it till 755. then i would use a VLOOKUP formula to find the barcodes of the row and paste the barcodes in Book2.xls.

my final result of book 2 would be:

2 102
4 167
5 178
7 250
9 356
11 678
12 679
13 755


but i want to do this via macro as there are multiple files to deal with. and it becomes very irritating to copy paste manually the columns.
i wish to use the macro in Book2.xls so tht it would automatically calculate the missing barcodes of Book1.xls .

please help as there are more than 200 files and manually doing this would be a headache. My boss has asked to find the missing barcodes and print them in book2.xls and send it to him