Combining data from multiple worksheets into master worksheet

J

Jill

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
 

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

linking multiple worksheets and master completes next available li 1
How to update data from linked worksheet back to a master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
combining data from multiple worksheets into one 6
identifying data from a separate worksheet 1
Summarizing multiple worksheet data 0
synchronize worksheets with master worksheet 2
need help with formula 0

Top