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

match two cells from one worksheet to another 3
Match text to another worksheet and return a certain value 4
Help to build a Look Up Function or What Ever Function Excel 2002 6
Need Excel Function to FIND Text - Help! 4
index match array function-returning only first match, need last. 3
Kinda like a database - I can’t believe others don’t need to do th 3
Provide a match from 2 cells to give a result from another 4
Matching value of a cell to a sheet name 1

Top