Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from multiple worksheets into master worksheet
Here's what I'm trying to do. I've got an employee vacation spreadsheet. In
that spreadsheet each employee (total of 62) has an identical worksheet that shows a scaled down version of each month for the 2009 year. When they sumbit a request I enter a V in the space provided for that given date. Now what I am needing to do is take the combined information from all of the employee worksheets and create a master worksheet for each month showing who all is scheduled off each day. Like a snapshot. Any help would be GREATLY appreciated. I can email this file out if it will help. Thank you so much! Jill |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from multiple worksheets into master worksheet
Hi,
You can mail it to me at . -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jill" wrote in message ... Here's what I'm trying to do. I've got an employee vacation spreadsheet. In that spreadsheet each employee (total of 62) has an identical worksheet that shows a scaled down version of each month for the 2009 year. When they sumbit a request I enter a V in the space provided for that given date. Now what I am needing to do is take the combined information from all of the employee worksheets and create a master worksheet for each month showing who all is scheduled off each day. Like a snapshot. Any help would be GREATLY appreciated. I can email this file out if it will help. Thank you so much! Jill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple worksheets linked to a master worksheet | Excel Worksheet Functions | |||
pulling data into a master sheet from multiple worksheets | Excel Worksheet Functions | |||
Sorting data from multiple worksheets into a master sheet/tab | Excel Worksheet Functions | |||
How do I filter data from a master worksheet to other worksheets | Excel Discussion (Misc queries) | |||
Master worksheet linking to multiple worksheets and using filter | Excel Discussion (Misc queries) |