I am creating a totals sheet for the year based off of monthly sheets which
include employees name and salary paid. I have each employee on its own -
same line between the sheets so my totals are fine. However on the total
sheet I would like to pull the employee names onto the sheet. Some months
include different employees than others - each employee no matter what has
its own line - some lines are blank on somesheet. Some employees are on
every month's sheet.I tried

='Jan 04:Dec 04'!A6

and I get #REF returned

Please help,
Barb

You need to create a Pivot table using the "multiple consolidation ranges"
option. This web sit eis a good place to start to learn how but by all means
do a google search on "multiple consolidation ranges"
http://www.contextures.com/xlPivot08.html

HTH Marty


"babs" wrote:

I am creating a totals sheet for the year based off of monthly sheets which
include employees name and salary paid. I have each employee on its own -
same line between the sheets so my totals are fine. However on the total
sheet I would like to pull the employee names onto the sheet. Some months
include different employees than others - each employee no matter what has
its own line - some lines are blank on somesheet. Some employees are on
every month's sheet.I tried

='Jan 04:Dec 04'!A6

and I get #REF returned

Please help,
Barb

This is not working for me because to get the total within each worksheet I
had to use and If - Isnumber function to ignore 0's. The pivot table is
mixing the order of the names up also. Please see original explanation - any
other ideas to get the names of people on the total sheet- any sort of
Function???

Thanks,
Barb

"marty" wrote:

You need to create a Pivot table using the "multiple consolidation ranges"
option. This web sit eis a good place to start to learn how but by all means
do a google search on "multiple consolidation ranges"
http://www.contextures.com/xlPivot08.html

HTH Marty


"babs" wrote:

I am creating a totals sheet for the year based off of monthly sheets which
include employees name and salary paid. I have each employee on its own -
same line between the sheets so my totals are fine. However on the total
sheet I would like to pull the employee names onto the sheet. Some months
include different employees than others - each employee no matter what has
its own line - some lines are blank on somesheet. Some employees are on
every month's sheet.I tried

='Jan 04:Dec 04'!A6

and I get #REF returned

Please help,
Barb

What exactly is in A6 that you are trying to put into the Totals sheet?
If you are trying to sum the salaries from each month you need to use
=SUM('Jan 04:Dec 04'!A6). If you need to match the salary to specific
names on different worksheets then you may need to use a MATCH or
VLOOKUP.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508505

I have each employee on its own -
same line between the sheets so my totals are fine. However on the total
sheet I would like to pull the employee names onto the sheet. Therefore to
answer your question I just need to get the employees name onto the summary
sheet - that is what is in A6. Some months
include different employees than others - each employee no matter what has
its own line - some lines are blank on some sheets. Some employees are on
every month's sheet.I tried

='Jan 04:Dec 04'!A6

and I get #REF returned

Example of what I have - (Totals summary of the employees salaries - I
have) just need to get the list of employees- next to their given total-each
have own line!!


January list of employess

A6 Bob J.
A7 Bob R.
A8 Tony V.
A9 Gary E.
A10 Jerry Z.
A11 Nelson E.
A12 Bozo
A13 Linda L.
A14 Gene P.

Feb list of employees

A6 is BLank
A7 Bob R.
A8 Tony V.
A9 Gary E.
A10 Jerry Z.
A11 Nelson E.
A12 Bozo
A13 Linda L.
A14 Gene P.
A15 Joe

So Joe stays on A15 between all the sheets but a15 in Jan. is blank

A6 in Jan is Bob J and in Feb A6 is Blank but Bob J shows up again in May on
A^.

Set up sheets so that all employess have their own row.

just want a FINAL Complete list for Total sheet without using Vlookup, match
or pivot table.


ex.

Total sheet

A6 Bob J
A7 Bob R.
A8 Tony V.
A9 Gary E.
A10 Jerry Z.
A11 Nelson E.
A12 Bozo
A13 Linda L.
A14 Gene P.
A15 Joe

Hope this clears up what I am looking for.

Thanks,
Barb



"mphell0" wrote:


What exactly is in A6 that you are trying to put into the Totals sheet?
If you are trying to sum the salaries from each month you need to use
=SUM('Jan 04:Dec 04'!A6). If you need to match the salary to specific
names on different worksheets then you may need to use a MATCH or
VLOOKUP.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508505

Do you have to leave the Name cell blank if they did not get paid in
that
particular month? If you leave their name in there and just list their
salary
as zero then your December sheet will have a list of all employees who
have
worked the previous year you can just put

=Dec 04!A6

I will have to think about it some more if you must leave them blank.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508505

Yes,

I do need to leave them blank if they did not get paid for that month.

Thanks,
Barb

"mphell0" wrote:


Do you have to leave the Name cell blank if they did not get paid in
that
particular month? If you leave their name in there and just list their
salary
as zero then your December sheet will have a list of all employees who
have
worked the previous year you can just put

=Dec 04!A6

I will have to think about it some more if you must leave them blank.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508505