How to update row data from one sheet to another or add new data by VBA.

[knaabis]

There are two Excel sheets. One sheet - work DB and second archive DB.
I want to update lines from work DB sheet identical lines in archive DB by row ID number (column A data) or add new data lines in archive DB sheet.

 

[knaabis]

Does anyone have any idea?
Please!

 

[knaabis]

Actuall DB - it's today's data.
Archive DB - before update.
Archive DB - after update

I need to VBA compare the Actual DB with the Archive DB and update the existing data and add the new ones.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Actuall DB					Archive DB					Archive DB after update
2	ID	one	two	three		ID	one	two	three		ID	one	two	three
3	10	1	2	3		10	1	2	3		10	1	2	3
4	20	4	5	6		20	4	5	6		20	4	5	6
5	30	7	8	9		30			9		30	7	8	9
6	40	11	12	13							40	11	12	13
Sheet1

 

[knaabis]

Problem not solved yet...