Compare values in column B of sheet 1 with all the values of Column A in sheet2

[aman1234]

Hi Guys

I have to do the following steps. I have written the code but its not working properly:

1. Select the first entry in Sheet (Inventory), column B (Barcode)
2. Search for a match on Sheet(Barcoded Files) Column A (Wincanton Code)
3. If there is a match, update the correct row in Sheet(Inventory) Column C (Issue) with the row number of the match from step 2 above & then proceed to step 5 below
4. If there is no match proceed to step 5
5. Select the next entry in Sheet (Inventory), column B (Barcode) and go to step 2


please see the code below. It takes ages to run:

Please Login or Register  to view this content.

ANy help would be much appreciated.

Thanks

[Richard Buttrey]

Hi,

Why are you using a macro, and a looping one at that to perform a task which from your description can probably be achieved with standard Excel functionality in a fraction of the time?

Even if the macro is part of another automated process you can still use standard functions to build the results for you.

Upload the workbook and manually add a selection of results so that we can see the end goal.

[nigelbloomy]

It looks like you could use a formula like this in C2 of your Inventory sheet and copy it down the column.

Please Login or Register  to view this content.