louche_boy
New Member
- Joined
- Mar 12, 2009
- Messages
- 2
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
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