I was reading what I had written and I forgot to say that an employee can be
listed in more that one cell and more than one location. They could be a .50
do one job and a .50 do the same job but at a different location. Do you
think you can still help?
--
Newfie


"Newfie809" wrote:

Yes there are 44 locations and the last sheet is number 45 (All Employees).
--
Newfie


"Newfie809" wrote:

Yes, that is correct Job Title for those employees is all the same and is in
Cell B8.
--
Newfie


"Otto Moehrbach" wrote:

Newfie

The "easier way" is VBA (programming). I'll try to work up
something for you but I need clarification on some of what you said.

You say:

Job Title for employees listed in

rows B9 to B48 is in row B8.

B8 is not a row. It is a cell. Do you mean that the job title for all
employees in B9:B48 is the same and that title is in cell B8?



You say that you want the Name, FTE, Job Title, and Location for each
employee to be placed in the last sheet. Is this "last sheet" one of the 44
sheets that already have employee data, or is this "last sheet" dedicated to
just the compilation of all 44 sheets and is therefore the 45th sheet? Otto

"Newfie809" wrote in message
...
I have a workbook that has 44 worksheets with a list of Employee Names,
FTE,
Job Title and their Location.

I have to list all information on one worksheet at the end, so I can
attach
their salaries and allowances for budget.

All worksheets are in the same format.

Location for all employees is D3 in all worksheet. and Emplyee names are
listed in rows B9 to B48, S4 to S26 and S29 to S52.Their FTE's are listed
in
rows C9 to C48, U4 to U26 and U29 to U52. Job Title for employees listed
in
rows B9 to B48 is in row B8. Job Title for employess rows S4 To S26, S29
to
S52 is listed in Rows R4 to R26 and R29 to R52.

Each worksheet might not have employees in all rows, some might have up to
40 employees and some as little as 8.

I have listed all information for each sheet in columns AA1 Name, AB1 FTE,
AC1 Job Title and AD1 Location, then on the last worksheet I did = for
each
cell that containe data.

I was hoping that there might be an easier way.

Thanks
--
Newfie