Transfer Data to Customer Database

[TheRobsterUK]

I'm trying to make a customer database where the user inputs some
details (ID, name, address etc) and then clicks a button and the data
is transferred to another table. Hopefully the diagram below will give
an idea what I mean:

http://www.sudsolutions.com/stuff/Excel_Table.JPG

But how do I get Excel to add the new customer details to the next
available empty slot?

I can get it to do it in a very basic way but it always has to select
the cells and for reasons I won't go into here it must do it without
having to actually select the cells in question.

I'm sure there's an easy VBA macro that could do this but I'm stumped.


Cheers
-Rob

 

[Guest]

The following may work, you will need to adapt the cell ranges appropriately.
If your database is in a different sheet, include the sheet name in the
Destination range:

Range("B33").Copy Destination:=Range("B6553665536").End(xlUp).Offset(1, 0)

HTH/

 

[TheRobsterUK]

Got it working with a slight change to the posted code.

Much appreciated Quartz.

-Rob