Quick question here. How would I program a cell to NOT change after a specific date? For instance, if I was to take today's spot price of gold from the web, but have it stay left behind in the previous cell. I feel like I'm so close, yet so far. Here's a test sheet I have made with the best I can come up with. The spot price isn't connected to the internet yet, I just want to make it functional first. Additionally, cell J1=TODAY()
Bookmarks