Hi

My problem:

I want to have on excel sheet where I can type in infomation:
Name
Year
...

When this have been entered I to click on a button and the want another sheet to collect (cut and paste) the infomation into a data-sheet!
After I have entered it would be nice if a message box would appear and after delete and be ready for a new input.
Offcourse that data-sheet should not delete any of the data - it should simply just paste into the next free empty row.

Can anybody help with a simple code???!


Many thanks!