I am trying to make to sheets:
The first I want is having some cells where I type in Name, Adresse, City and so on.
After I have entered this I have createt a command button. When I click this I want the to:
Copy the information from the cells
Pate the information from the cells in to a new sheet.
Have a MessageBox to say "Information have been submited" and then make the cells empty for new entries
When I repeat the I want the next information I type to be pasted into the nex row in "data"sheet.
Can anybody help wíth a code for the button?