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

Archive log register ?

I need help creating a logdate for my labs archive, for movement of samples in and out of archive.

Samples will be logged in manually like Sample_ID, date, client etc etc. When they are new.

But what im really struggling with is when existing samples in register are taken out and then returned.

I want to create checkboxes for in and out. That when they are ticked they save the current date the box was ticked. So then someone can see when sample was taken.

How can i use formulas on these checkboxes?

submitted by /u/Revolutionary-Ad7538
[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
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#Archive log register
#movement of samples
#logdate
#Samples
#checkboxes
#Sample_ID
#manual logging
#sample tracking
#formulas
#movement tracking
#checkmark
#in and out
#current date