Importing data and sorting by unique identifier

[louche_boy]

Hi all,

I'm pretty new with excel so thought I would consult this forum.

I have two datalists each with unique identifiers.

Essentially I want to merge the data onto one worksheet but there are more datasets on one sheet than the other.

Example: Worksheet one contains 500 employees with home details etc. and a unique identifier.

Worksheet two contains 300 employees with training details and unique identifier.

Employees are from same workplace. Essentially I would like to move the 300 employees data over to the 1st worksheet and have it automaticcally sorted (or data loaded) by unique identifier, leaving the employees with no training detail blank.

Any help would be appreciated.

Thanks.
Louchie

 

[Dougie1]

I will take it for granted that the sheet with the 500 Unique Identifiers is Sheet1 and that these are in column A and the home details are in column B.

I will also take it that your 300 Unique Identifiers are on Sheet2 and are in column A and that the training details are in column B.

I will also take it that both Sheet1 and Sheet2 have column headers in row A.

So in cell C2 of Sheet1, insert the following function :

=VLOOKUP(A2,Sheet2!$A$1:$B$301,2,FALSE)

and fill this down column C of Sheet1.

From the Edit menu : Copy and Paste Special values column C over itself.

Then from the Data menu : Sort Sheet1 by column A Ascending

That should sort you out.

Cheers,

D

 

[Dougie1]

Sorry - that should have said :

"I will also take it that both Sheet1 and Sheet2 have column headers in row 1"