merging data from multiple worksheets

[peadar]

Hello,
I have data on 2 worksheets that I want to merge together to form a single worksheet.
For example, both sheets have a name column, but then one sheet has a salary column and the second sheet has schedule column.
One concern is that the sheets don't have the same names.
Is there a way (with minimal manual intervention/typing) that I can merge these two sheets resulting in a list of names; some with salaries and schedules, then some with just salaries and some with just schedules?
Thank you in advance, Peter

[funkymonkUK]

Hello,
I have data on 2 worksheets that I want to merge together to form a single worksheet.
For example, both sheets have a name column, but then one sheet has a salary column and the second sheet has schedule column.
One concern is that the sheets don't have the same names.
Is there a way (with minimal manual intervention/typing) that I can merge these two sheets resulting in a list of names; some with salaries and schedules, then some with just salaries and some with just schedules?
Thank you in advance, Peter

give me any example to work with. i was thinking of maybe a look up table but need to see what you actual want.

[peadar]

Basically I have a name column in each sheet, most but not all, of the names are the same, some are unique to each sheet. Then one sheet has a salary for each name. Then the second sheet has a schedule for most of the names. So once I have a merged sheet, any duplicated names will occur once, with a salary and schedule. Then there would be some (additional) names with just a salary or just a schedule and possibly some names with no other data. But each name should occur only once in the merged sheet.

[cwinters]

Multiple step solution:

first get a master list of names.

1. on a new worksheet paste the names from worksheet#1 and worksheet#2 in one column.
2. Sort them.
3. In an adjacent column type =if(a2=a1,"REPEAT","OK") into cell b2. This will look for repeats of names.
4. copy the results in column b and paste special as values.
5. sort both columns by the b colum results, this will bring all repeats together.
6. delete repeats.
7. delete column b
8. sort the a column, this is your master list of names

Now do the lookups

1. in column b, which is now empty, do a =VLOOKUP formula to search your first worksheet for salaries.
2. in column c, do a =VLOOKUp formaul to search your 2nd worksheet for schedules.

tell me if this works for you.

[peadar]

I do not see how the vlookup function will get data from another worksheet.
It seems to only get the data from within a range of cells in the current worksheet?