Upload data according to header column

[Deleted member 175603]

Hi there,

I need some help in find a solution to help me to simplify a way of matching the complex data using macro. Here is my data formats look like in 2 separate excel files.

File 1:
------

Part# Start Date WW1 WW2 WW3
--------------------------------------------
1234 1-Mar-2011 0



File 2:
-----

Part# Start Date WW2 WW3 WW4
---------------------------------------------
1234 8-Mar-2011 10



Every week, I will have a different workweek (WW) data generated and it will need to be consolidated into one database with showing overall WW together, which look as following:

Final Database
--------------

Part# Start Date WW1 WW2 WW3 WW4
---------------------------------------------------
1234 1-Mar-2011 0
1234 8-Mar-2011 10


I only using the manual way of cut and paste method to do such data transfer, but due to the huge data that I am dealing with, it will be very painful process to do so. Is there any way/solution that can be use (like using macro or VB script) to automate it without required any cut/paste anymore?

Please help me on this...Thanks in advance.