Excel front end?

Hi,

I've got a a fairly basic grasp of Excel and I want to make a "front end" to one of my spreadsheets.

I want to be able to input data on the first sheet of the workbook so that it's copied to a second sheet in the workbook where I've got various calculations happening.

The thing is I want to be able to reset the "front end" bit so I can input more data and that will get copied to a different blank row in the second sheet rather than replacing previously submitted data.

Can someone please advise me if this is possible and how I would go about doing it?!

Any help is greatly appreciated

That's brilliant exactly the sort of thing I was looking for. Thanks for your help and your example davesexcel!

Hi, I know this is an old thread, I found the solution in here perfect for my needs however I want to prevent duplication. So if my staff enter a value that already exits in the 2nd sheet it warns then and then clears the cell.

any help would be apreciated