So I have a list of people that get assigned a random group every week. Is there a simple way to keep track of the history of which groups they were assigned each week? So what I’m looking for would look something like this:
Thanks for your help!
I do something a little bit more elaborate to keep a record of weekly updates.
Pushing the button will copy the previous comment to an archive column, and it currently add todays date to the update column.
This is the code for the button:
If you do not need the date, you can remove the lines in italics.
[Action Item List].[Action Update archive],
thisRow.[Action update], Character(10), thisRow.[Action Update archive]
[Action Item List].[Action update],