Macros

[Andrea]

I am looking for help with Macros. I have recorded a
macro in xl2k that opens a 2nd spreadsheet, copies
information from the first to the 2nd spreadsheet and then
saves and closes the 2nd spreadsheet. The problem I am
having is writing into the macro that I want the data to
copy to the first open row instead of copying over the
data that exists from the last time the macro was run...
I'm sure it can be done. I just don't know how to do it.

Thanks for any help in advance...
Andrea

 

[Gord Dibben]

Andrea

This macro will find the bottom row of data in Column A on Sheet2 then select
the first cell below that. Incorporate the code into your paste macro.

Sub findbottom()
Worksheets("Sheet2").Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Select
End Sub

Gord Dibben Excel MVP XL2002