I have a file with 31 worksheets, one for each day of my accounting period.
Each worksheet is divided into 2 parts, daily and period to date. I am
trying to calculate the rolling totals each day. I can do it, but reentering
the manipulated formulas for each day is very time consuming. Isn't there a
way to pull data from a previous worksheet by using a command "previous"? I
could've sworn I've seen it somewhere before.