It's hard to give specific help since you didn't post any code. But in
general, a good way to find the "next empty cell" is to go end up from the
last row and then down one. This is an example for column A

Range("A65536").End(xlUp).Offset(1).Select

--
Jim
"Carrie" wrote in message
...
| 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!!