I have a spreadsheet where the values change daily. I would like the values permanently recorded and saved automatically in a list showing what the value was and on what day. I tried using if-then-else and datevalue but when the date changes to the next day it just picks up the new value instead of retaining the original one. ???
Bookmarks