Forum Discussion
Tom_M_1969
Dec 13, 2021Copper Contributor
Time tracking with a scanner without VBA?
Hello all - I'm trying to set up a document in a shared, online Excel document that will allow employees to be scanned in and out to track their time. Because I'm using the online version of Exce...
mtarler
Dec 14, 2021Silver Contributor
I am curious how your are doing this now. I suspect just to get the data from the scanner you need the macro. I don't see any way that worksheet functions will do this but there are other options including scripts and power automate that might help, but I still don't know exactly what you have going on right now (i.e. exactly how is the data getting into the sheet in the first place)