I need to run vlookup to compare two set of data and i want it to be automated.

[mikail]

I attached a file that contains two tabs.

In New Order tab, it contains a set of data that i received from supplier.I will receive the update daily.

My task is to register the records in our internal system.

Before doing that, i need to run vlookup to check if the new data new data alraedy created in our system by comparing the data in New Order with data in Registration tab.

If the record alraedy exist in Registration tab, the cell E will appear as Yes and if it is not, the result is No.

I have more that 3000 records and i'm repeating the same step everyday.I wish i can get this automated.

Any help is greatly appreciated.

[:) Sixthsense :)]

Please confirm which are all the cells data needs to be considered for comparison?

[mikail]

Hi Sixthsense,
I want to compare serial number from registration tab (Cell C) and serial number in new order tab (Cell D).
If it is matching, it returns result as Yes. If it is not, it will return result as No.

Please help me..

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[mikail]

HiSixthsense,
Thanks for your help.
It is working.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep