Need a function to match up jobs

L

Lynda

I have a master sheet with about 50 different job descriptions, then I have
about 20 more worksheets that could have between 20 and maybe 40 job
descriptions with the number of people against them.
I want to put them all on the master sheet against the appropriate job
description but keeping them in columns against their appropriate worksheet
without having to go through and enter everything manually.

Master Sheet Worksheet1 Worksheet2
Accountant Accountant 40
Bookkeeper Bookkeeper 15 Bookkeeper 20
Finance Manager Finance Manager 12
General Clerk General Clerk 20

Etc.

I hope this all makes sense.
Thanks in advance
Lynda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup cell next to data 2
match two cells from one worksheet to another 3
Help to build a Look Up Function or What Ever Function Excel 2002 6
I need a Formula for a Database 3
IF function - need FALSE to return a blank cell, not 0 1
Tally function assistance 4
OFFSET function 1
Lookup? Match? pulling rows from one spreadsheet to match a text f 3

Top