Macro to Update Master Table with partial data from Source Table

[wiseone]

Hi All,

New problem I'm trying to get an idea on how to execute with VB.

I have a master table with 100 columns and 5000 rows (Table 1).

I also have a source data table in another workbook which is only 10 columns and 500 rows (TABLE 2) (which have 10 matching column headers to TABLE 1).

Both tables have a column A with unique identifiers, But table 2 may have less of them. For both tables, each column may or may not have data.

Any ideas on how to make a macro which will overwrite the cells in TABLE 1 with data from TABLE 2 with the corresponding data ONLY if the data is different than what is already in TABLE 1 and leave blank if blank?

The Master Table (TABLE1) - Holds a master list of unique identifiers and does not need to call any new identifers in (TABLE 2).

All cells must be values only.

Thanks in Advance!

Example:

MASTER TABLE - TABLE 1:

	A	B	C	D	E	F	G	H	~	DC
1	aaa	yes	10	etc
2	bbb		20
3	ccc	no	10
4	ddd	yes
5	eee	no	10
6	fff
7	ggg	yes	50
8	hhh	no	40
9	iii	yes

<tbody>
</tbody>

Source Table - TABLE2

	A	B	C	D	E	F	G	H
1	aaa		55
2	ddd	no	20
3	ggg	no	50

<tbody>
</tbody>

RESULT - Updated Master Table (TABLE 1)

A	B	C	D	E	F	G	H	~	DC
1	aaa	yes	55	etc
2	bbb		20
3	ccc	no	10
4	ddd	no	20
5	eee	no	10
6	fff
7	ggg	no	50
8	hhh	no	40
9	iii	yes

<tbody>
</tbody>

 

[wiseone]

I managed to fix this....there was one identifier cell with #Ref! in it causing the error.