Hi everyone.
I am trying to create a form on Excel that does the following:
The user enters a piece of data unto 3-4 columns. The user then hits a
function start key. The data is then stored in a different sheet using the
next available line. I do not know
VB except for BASIC Macros.
I tried creating a counter using the "counta" function. This worked. I
then created a Macro to cut and paste this value on the "Go to" command but
the issue there was it did not update the new value and always went to the
first cell that I originally selected.
Any thoughts how to do this in an uncomplicated way?