Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals sheet - deal with employee names
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
reference to sheets without using sheet names | Excel Worksheet Functions | |||
Get other sheet names into a column | Excel Worksheet Functions | |||
calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
How can I show sheet names in different colours | New Users to Excel |