Forum

Notifications
Clear all

Keeping record of changes (in other sheet) in a checklist in shared workbook

2 Posts
2 Users
0 Reactions
80 Views
(@azidgill)
Posts: 15
Eminent Member
Topic starter
 

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. 

 
Posted : 25/03/2021 1:06 am
(@questvba)
Posts: 125
Estimable Member
 

Hi Azid,

The excel file is not attached. When you have added it via Add Files, you must then press Start Upload.

From what I understand, it should be automated via a macro. You should ask your question in the VBA & Macro forum : Excel-Forum/vba-macros

BR,

Lionel

 
Posted : 25/03/2021 2:02 am
Share: