Hi,
I am trying to track timeshare points I have. I get 29000 point (called new points) on 8/1 every year and they are good for 2 years. However, they lose value when they rollover to the second year (called saved points).
What I want to do on Aug. 1st each year is:
- have the data in cell F2 (new points) move to G2 (saved points)
- Have the data in G2 (saved point) move to H2 (expired points)
- have the data H2 (expired points) keep a running sum of points that might expire over the years
I also can't figure out how to have text and numbers in the same call and be able to have that cell be used in a formula to sum cells.
Thank you,
Mike
Bookmarks