How to do it - please help me! Urgent.

[KaZetE]

Hi,

I'll describe my problem using a simple example.

I have two sheets.
Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and other data in columns K1,K2,K3,K4.
Sheet 2 contains records (rows) with identifiers X2,X4,X5
(in column K0) and other data in columns K5,K6,K7.
All identifiers which are in Sheet 2 are in Sheet 1.
I want to have a Sheet 3 (or updated Sheet 1)
containing records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and columns K1,K2,K3,K4,K5,K6,K7
where data in columns K1,K2,K3,K4 are from Sheet1
and data in columns K5,K6,K7 are from Sheet 2.
How to do it?
In real example there are hundreds of records.
Please help me. It is urgent.

Regards

 

[Luke M]

Please see your other post for my answer.