Forumla to update changing totals

Originally Posted by JHillestad

I created a spreadsheet to track employees vacation usage using Excel. The manager wants a summary page where it shows each employee and their balance. The spreadsheet that I created has a row for each day of the year so the total is constantly changing. Is there a formula or a way to have the total on the summary page for the employee update if the total would change on the tracking page?

Any thoughts would be helpful! Thanks for your help!

Hi,

there are formulae to add things, copy things, extract things, and many others, however, a Formula needs to know the Sheetname and the Cells (or Rows &/or Columns) from which the formula will gather information.

Perhaps a sample of your worksheets would help in the setting up of any formula.

---