LinkBack URL
About LinkBacks
I want a macro to run when a cell value changes, which is straight forward. However i want the macro to use the value which was in the cell prior to it changing, is this possible??
I want a macro to run when a cell value changes, which is straight forward. However i want the macro to use the value which was in the cell prior to it changing, is this possible??
You don't explain what you want to do with the previous value...
But try something like this in your worksheet module:
Obviously, change the worksheet_change event code to suit your needs, but it shows how you can use the previous cell value.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks for the reply, i should of probably explained myself a bit better.
So i essentially will have a copy of worksheet, though the values in this duplicate will have the cell value before a cell value is changed in the original worksheet.
If anything, that explanation made it less clear.
Does my code not do what you want? if not - then try posting a workbook to explain your requirement more clearly. Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks