Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding info in the row at the bottom using macro?
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!! |
#2
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
Date macro | Excel Discussion (Misc queries) | |||
Adding info onto a "permanent" form | Excel Worksheet Functions | |||
macro - adding rows to a column that is summed | Excel Discussion (Misc queries) |