Copy & Paste macro

S

sparx

Please can anybody help - I have 2 database's in excel. At present
copy a range of cells in database 2 and in database 1 find the nex
empty "column A" row and then paste ( values only ) the data. Is ther
a macro that could do this for me so it looks down "column A" and find
the next empty row cell then copies the data into it - there is a catc
though - it must copy as values not a straight forward copy
 
S

sparx

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