Forum Discussion
Transferring the contents of a cell to an adjacent cell when it is changed
What you're asking is almost certainly possible. One of the biggest factors in making it readily/easily possible is the matter of how your raw data are organized.
Toward that end, I wonder if it would be possible for you to post a copy of your workbook (after changing any names to the names of, say, Disney or Star Wars characters), so that we could see how you've organized things, and possibly make suggestions on how to re-organize (if needed) and then how to achieve the kind of tracking of status changes. Post the file(s) on OneDrive or GoogleDrive and then paste a link here that grants access.
mathetes Thank you for your response - I've spent some time "cleaning" my report spreadsheet so that I can share it on here without any repercussions at work, but I can't find a means to upload it - any ideas?
See the last sentence in my prior message. You will be able to post it on OneDrive or Google Drive and then paste a link here that grant access to the file.
mathetes - apologies for missing your direction in your first response - thank you for clarifying.
https://docs.google.com/spreadsheets/d/18TaQo_PvuvXQEqwEttGTcIVsrCZ6lJGk/edit?usp=sharing&ouid=114796826648576103569&rtpof=true&sd=true
So in this workbook, its the cells that I've highlighted in yellow, along with similar cells located in M4:M10, X4:X10 and AI4:AI10 that I wanted to track the change of. It doesn't matter too much to me where the audit trail is held, as long as it is on the same worksheet and it doesn't interfere with the existing tables that are already in the worksheet.
What I want to be able to do, is run a query to find the 'latest' update in a given weeknum (current weeknum) and return a True if it differs from the previous weeknum, and a False if it doesn't...
Thanks for your time and patience.
The two features which might be of use here:
Show changes:
Get help with Show Changes in Excel - Microsoft Support
Provides an extensive list of edits made to a workbook. Must store the workbook in the cloud. The 'audit trail' is not displayed in sheet but rather in the show changes pane. Available in Excel for Web and some versions of Excel 365.
Spreadsheet Compare (aka Inquire's Compare Files)
A quick way to obtain the differences between two different Excel workbooks. It's very robust but you'd have to run it manually and also maintain versions for the workbook.
