To shorten up your question are you looking to find the first blank row and
paste your data there? if so then you might be able to do something like

range("A65535").end(xlUp).offset(1,0).select

to select the first blank cell in column A.

HTH

"Jane" wrote:

Hi all,

I am trying to export data through the means of a button placed in excel,
where the macro will copy 2 cells and paste it onto another spreadsheet. This
is not where I need the help, what I am finding difficulty doing is having
the macro not overwrite existing imported data on the other spreasheet.

I want the macro to actually build up a database the another
spreadsheet...if that makes sense. I am aware of the wiazrd template, but I
don't want to take that approach.

Is there a way to give the macro logic in saying if cell x and cell x is
populated then paste data in cell x and cell x, preferably the row below
existing data.

Thanks