Merging Various versions of a work book in one.

[ni.va]

Hi,

I have two versions of excel files like this:

Audit 1

    A       B     C     D
1 Comp.   2010  2009  2008
2   X      2       
3   Y            2      2
4   Z

Audit 2

    A       B     C     D
1 Comp.   2010  2009  2008
2   X            
3   Y                   2
4   Z      2     2

I want to merge these two in Audit 1 & get:

    A       B     C     D
1 Comp.   2010  2009  2008
2   X      2       
3   Y            2      2
4   Z      2     2

the data is stored in a table with about 500 rows & 70 columns

any help would be appreciated.