transfering data from a registration sheet

gjb5

New Member
Joined
Mar 17, 2009
Messages
19
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?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hello and welcome to MrExcel.

Something like:

Code:
Sub test()
Dim LR As Long
LR = Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row
With Sheets("Sheet1").Range("A2:G2")
    .Cut Destination:=Sheets("Sheet2").Range("A" & LR + 1)
End With
End Sub
 
Upvote 0
VoG.

Thanks you for your speedy reply. I've ran the code but I think each registration will replace ther last one. Is there any way of getting the first registaion in row A, the second in row B and so on?

Apologies if i've misinterpreted your repsonse
 
Upvote 0
My code will place the first set of data in row 2 of sheet2, the second set in row 3 and so on.

Perhaps if you post your existing code we can modify it.
 
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top