Multiple Worksheets and formulas

  • Thread starter Thread starter lldickey2003
  • Start date Start date
L

lldickey2003

Hi, I hope someone can help...I have a vacation/PTO workbook that has
18 different worksheets in it, one for each employee. I have added a
19th worksheet to keep track of the PTO by itself. I need to create a
formula so that when I update each employees sheet individually, it
will automatically update the PTO sheet without me having to go and
manually change the total in the PTO sheet. Can someone help me, I've
never had to do this, but I know there has to be a way!
THANKS!!!!!
 
I hope I understood your question. You would need to have a running total of
vacation time on each employee page. Then on your summary page, you reference
that running total. ANy change to an employee should be reflected in the
summary page.
 
Back
Top