Hello
Let's say that I have some text in the cells A5 to A15. If I replace some of the text, I want to show the last changed cell in cell C1 without using Pivot or VBA. Is this possible?
Hello
Let's say that I have some text in the cells A5 to A15. If I replace some of the text, I want to show the last changed cell in cell C1 without using Pivot or VBA. Is this possible?
You could use "track changes" on the review ribbon. Set it to create a separate worksheet listing all changes. Then you could add a vlookup in cell C1 to get the most recent change.
formula could be something like...
=VLOOKUP(MAX(History!A:A),History!A:G,7,0)
Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks