1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need to generate timestamps easily without using VBA. Ideas?

Occasionally, I have my staff do productivity timings using an extremely simple Excel sheet. Using VBA... Click this cell to generate a start time, click this cell to generate an end time. So each row is basically a widget of work... They click the start time cell, do the work, click the end time cell, categorize it with some drop-downs, move on. Easy.

However, the corporation is disabling all Microsoft macro use over security concerns, and my staff will no longer be authorized to use them. So I'm trying to come up with an extremely simple, user-friendly way for them to generate start and end times on an Excel sheet... without using VBA. And I mean... so easy a caveman could do it. But I truly have no idea where to start with something like that.

Also open to not using Excel at all if there's a better way (like SharePoint).

submitted by /u/stevenchase87
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#timestamps
#Excel
#VBA
#start time
#end time
#productivity timings
#user-friendly
#extremely simple
#start and end times
#drop-downs
#security concerns
#simple Excel sheet