Hi,

I need some help on below scenario.

I have an Excel workbook with Sheet 1 and Sheet 2

In Sheet 1 I have the following data in column A

A
--------
USA
Germany
Italy
China

In Sheet 2, I have the following data in Column A and B

A B
---------------------------
Italy 320
USA 400
China 120
Germany 50

I need a VBA code that reads the data from Sheet 2, matches Sheet 2 column A value with Sheet 1 column A value and update the value of Sheet 2 column B to Sheet 1 column B respectively.

The actual scenario is my users will be having Sheet 1 with them. Sheet 2 is actually another Excel file received from other source. My idea is to provide a code so that they can merge the values into one sheet as above.

Anyone can help on this. thanks

Hi

Have you tried using Excel as a DAtabase. This would be really helpful for your scenario. Please try using ADO connection for Excel

You can also try for QueryTables

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,

Its a great idea. Thanks. However I would prefer to do it using VBA code. I want to make the process as simple as possible as this will just be an supporting tool for them.
Any help ? Thanks