Hello.
I'm trying to create an Excel sheet that allows a number of people to input information about individual clients which will be updated over time. I've created a registration sheet which requires the name, date of birth and registartion date of the client. I then created a macro which copies the data into a second sheet and clears the registration sheet so another client can be registered.
Th only problem is that i can't make the macro clear the regaistrtion form, copy the data and go down to the next row where the next client's data will stored when the macro is re-run.
Any thoughts on how this can achieved?
I'm trying to create an Excel sheet that allows a number of people to input information about individual clients which will be updated over time. I've created a registration sheet which requires the name, date of birth and registartion date of the client. I then created a macro which copies the data into a second sheet and clears the registration sheet so another client can be registered.
Th only problem is that i can't make the macro clear the regaistrtion form, copy the data and go down to the next row where the next client's data will stored when the macro is re-run.
Any thoughts on how this can achieved?