Thread: Exporting data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jane Jane is offline
external usenet poster
 
Posts: 202
Default Exporting data

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