Hi all!

I'm very new to Excel and all it's possibilities. I'm comfortable with the Windows OS, Word and Outlook but quite clueless when it comes to Excel things. I've done most of the "Excel 2010 for dummies" book but it doesn't seem to go in depth enough for what I'm trying to do.

We have 30 employees and I have been given an Excel file to work with. It has the days of the month and the names of the employees on 12 sheets, then a summary page with Name, Dept, Hire date, Today's date, # of days employed, Vacation accrual hours/day, hours accrued, total hours taken as of Dec 31 09, Total hours taken in 2010, Total hours taken in 2011, total hours taken as of (today's date), hours balance, hourly rate, Value of Vacation and annual Salary.

I'm supposed to make a simpler easy to work with file and I'm quite overwhelmed with the whole thing. I can make a pivot table out of the summary page but not out of the monthly pages.

It's hard to picture, but does anyone know of ways I can make it more user-friendly? Also I'm not sure why I can't make the monthly pages in to pivot tables.

Thank you in advance!!

Hi,

Happy to help, but for this type of project you will have to supply some example data.

If you could post a "dummy" workbook, with no real names or anything else confidential attached that would be a great start.

If you're not happy posting it here, PM me and I'll give you an email address you can send it to.

S.

I'll make a copy of the sheets with dummy info in them, thanks!

When I try to change the employee's names it messes up everything, and I can't risk my employment by giving out people's real names, even if it's just to you via email. Thank you for trying!!

You could make a backup copy and use find and replace to change each name to something different... Change Spencer Davis to Name 1 and Sammy Davis to Name 2 etc.

Might take a while depending on how many names there are in your workbook, but might be the difference between you getting the help you need and not.

I can't upload it to this site in the Excel format and it's too big when in PDF and in .txt I'd have to save and upload all 13 pages, too many for the site.

Holy CRAP this is frustrating. I PM'd you for that email address.

Yeah this forum is frustrating when it comes to file restrictions.
But I'm sure there are reasons behind it.

Email address sent back to you by PM.