troubleshooting Question

Need Excel code to track change in a single field

Avatar of terpsichore
terpsichore asked on
Microsoft ExcelVisual Basic.NET
7 Comments1 Solution505 ViewsLast Modified:
Dear expert!
I urgently need help on this.
I have a spreadsheet; on the first tab, there is a calculated field in cell E28. I want, on a separate tab in the same spreadsheet (let's call it "Changes"), to track the value of this cell along with the date, every time this spreadsheet is saved.
How do I do this? (I found a few similar questions, but didn't have the acumen to extrapolate).

Many thanks!
Wayne Taylor (webtubbs)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros