Hi,
got this file sometime back, but can figure how the original owner did the macro, can anyone help?

Basically, want to know how we input under 'template' sheet, and when click on botton below, it creates a new record in another sheet. and everytime I create a new entry in 'template' it will be inserted as a new entry in the next line in the 'database' sheet.

You can download the file from
http://www.streamload.com

Login as: peppercrab
password: liverpool

Have check for virus, so no need to be worry. Sorry for the trouble as this forum does not allow excel format attachment.