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.)
Hello all,
How do I create a formula or Macro that will automatically collect entered data according to serial number, date & time, and description in order and place them chronologically at the bottom of the document? Also, is there a formula or IF factor I can add to a line that will allow a blank cell to clear out another cell in another location of the document?
There is no formula that enters data in a worksheet. Only the user can do it or a macro, for instance one written in VBA programming language.
The easiest way to write a macro is to let the builtin macro recorder do it for you. Usually, the code resulting from that exercise will be good as a guide for adapting an idea rather than ready-to-use code. Especially for a relatively complex task like data entry it may be better to start with a Google search and a site like this one. Then use the macro recorder to find code snippets for the inevitable customisation.
Talking of customisation, once you have working code and want to add or modify features of it you can also post it here and ask a question.
