Keeping record of changes (in other sheet) in a checklist in shared workbook
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Azid Imdad
1
Reputation point
Hi Excel Gurus,
I have created checklist with the help of checkboxes in a sheet in excel workbook shared in sharePoint. I want to make auto generate repot in other sheet (in same workbook) which can keep auto record of person who ticket checkbox, time and date (prefer to hide report sheet).
Can someone please help how to do that. Excel workbook is attached.
{count} votes
-
Emily Hua-MSFT 27,526 Reputation points2021-03-25T06:26:19.107+00:00 @Azid Imdad
As the tag "office-excel-itpro" focus more on general issues of Excel, but your issue may need some code to complete this automated operation, I would remove it.
Thanks for your understanding.
Sign in to comment