Forum Discussion
Transferring the contents of a cell to an adjacent cell when it is changed
Hi, first time poster here, so hopefully I’m not about to ask for the moon on a stick – apologies in advance if my query is asking too much.
I have seen a number of other queries similar to my own, but none of the solutions actually fully fit my criteria and I don’t have the VBA skills to modify those that are close so that they work. Hopefully, someone will be able to point me in the right direction…
I have a report that is produced weekly, and that report contains the progress on 17 subjects, most of which don’t progress week on week. I have to produce this report against 20+ clients and most of my time is being spent typing the same “no update” update… As a result, I’ve turned to Excel and put each clients report into a separate worksheet. Now what I want to do, is work within the individual subject boxes (there are a few tick boxes to complete for each subject etc) and where that subject has moved from “In Progress” to “At Risk” I want to record that status change and effectively timestamp the week number that it changed so that that update can be automatically pulled into the corresponding weeks report.
I really wanted to be able to follow the audit trail of a subject also over the past 6-12 months rather than only seeing the previous status and the current one. Is this possible please?
11 Replies
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.
