This is difficult to explain but here i go.

I want to be able to add new pieces of infomation into a database using a
macro.

For example: A new customer sheet, Name, Address etc.... then i want to
duplicate this information into a database using a macro. (hope that makes
sense)

The problem that i keep having is that i record the macro to one particular
row and then each time i enter a new customer it over writes it.

I want to be able to add the new customer in the row below the last row
entered.

Please help!!