I'm new to the world of excel. I have a route sheet that I use for keeping track of customer project completion status/updates and things like that. Is it possible in excel to transfer a row when a check box is clicked? What about instead of replacing a time stamp with a new on in a cell, creating a log of every update time for said
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
To do/task sheet automation
0
Answers
0
Hi Attackmac and welcome to the Forum
All these things are possible but will need coding using VBA, Visual Basic for Applications, the language built-in (apart from web and mobile versions of Excel).
I'd suggest first you familiarise with Excel a little before attempting your logging project. The Tutorials section of this site Excel Tips and Tutorials is a great place to start.
On a "timestamp" issue for example, at a worksheet level, you may be aware that one can be created using this formula in a cell:
=NOW()That can be automated with VBA- see the example in the Tutorials section here: Automatically Timestamp Entries in Excel.
Please try those things (and modify to your "route sheet" and come back if you get stuck.