save the two workbooks and open both of them
the data are in sheet1 of the two books in column A1 on
you want to copy data in column A of sheet1 of book2 to shee1 of book1 at
the botttom of the data in col A.

then
in book2 goto sheet1 open control toolbox click <commanbutton and create it
somewhere in the sheet 1.
right clik this command button and click view code
you will get some thing like this
Private Sub CommandButton1_Click()

End Sub

above < end sub copy the following code

===========
Dim copydata As Range
Dim tocopy As Range
Windows("book3.xls").Activate
Set copydata = Worksheets("sheet1").Range("a1:a6")
Windows("book2.xls").Activate
Set tocopy = Worksheets("sheet1").Range("a1").End(xlDown).Offse t(1, 0)
copydata.Copy Destination:=tocopy
=========
click design icon to remove design mode

now if you click the command button hope you will get what you want.
if any bug let me know
--
remove $$$ from email addresss to send email
____________________________________________
"sparx" wrote in
message ...

Yes - I want to be able to highlight a certain cell in database 2 that
will say - press here to auto copy to database 1 then when you press it
- it highlights an area of data in database 2 and then looks down the
column A in database 1 until it finds the next empty row then paste's (
special ) the values then returns to the database 2.


--
sparx
------------------------------------------------------------------------
sparx's Profile:
http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=466723