Multiple Worksheets and formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lldickey2003@yahoo.com - 26 Jun 2007 15:03 GMT

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!!!!!

Reply to this Message

Uri - 26 Jun 2007 20:58 GMT

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.

> 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
[quoted text clipped - 4 lines]
> never had to do this, but I know there has to be a way!
> THANKS!!!!!

Reply to this Message