want to edit a macro to better meet my needs. Can't locate the keywords

I am trying to copy/paste a line of data from one worksheet to another. The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data to.
IE: keyword "next" moves the pointer to the cell to the right, I need to move
the cell down. The keyword "end(x1down)" moves the pointer down half page or
to the end of page.

"hecfrme" wrote:

want to edit a macro to better meet my needs. Can't locate the keywords

here's a simple routine you can possibly adapt to your situation. not sure
where your data is actually located, so i just used a1 thru e1 in my
example



Option Explicit

Dim lastrow As Long
Sub copydata()
lastrow = Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1,
0).Row

Range("A1:E1").Copy Sheets("Sheet2").Range("A" & lastrow)
End Sub

--


Gary


"hecfrme" wrote in message
...
I am trying to copy/paste a line of data from one worksheet to another.
The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data
to.
IE: keyword "next" moves the pointer to the cell to the right, I need to
move
the cell down. The keyword "end(x1down)" moves the pointer down half page
or
to the end of page.

"hecfrme" wrote:

want to edit a macro to better meet my needs. Can't locate the keywords

I would turn on the macro recorder, then carry out the steps manually. Look at
the generated code to learn the commands needed.


On Sat, 24 Sep 2005 14:11:02 -0700, "hecfrme"
wrote:

I am trying to copy/paste a line of data from one worksheet to another. The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data to.
IE: keyword "next" moves the pointer to the cell to the right, I need to move
the cell down. The keyword "end(x1down)" moves the pointer down half page or
to the end of page.

"hecfrme" wrote:

want to edit a macro to better meet my needs. Can't locate the keywords

I've done that and the problem is: macro assigns a specific line # and when
I repeat the macro it pastes over the last entry. Somehow I need to tell the
macro routine to move down 1 line.

"Myrna Larson" wrote:

I would turn on the macro recorder, then carry out the steps manually. Look at
the generated code to learn the commands needed.


On Sat, 24 Sep 2005 14:11:02 -0700, "hecfrme"
wrote:

I am trying to copy/paste a line of data from one worksheet to another. The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data to.
IE: keyword "next" moves the pointer to the cell to the right, I need to move
the cell down. The keyword "end(x1down)" moves the pointer down half page or
to the end of page.

"hecfrme" wrote:

want to edit a macro to better meet my needs. Can't locate the keywords

activeCell.offset(1,0).Select
--
Regards,
Tom Ogilvy

"hecfrme" wrote in message
...
I've done that and the problem is: macro assigns a specific line # and
when
I repeat the macro it pastes over the last entry. Somehow I need to tell
the
macro routine to move down 1 line.

"Myrna Larson" wrote:

I would turn on the macro recorder, then carry out the steps manually.
Look at
the generated code to learn the commands needed.


On Sat, 24 Sep 2005 14:11:02 -0700, "hecfrme"
wrote:

I am trying to copy/paste a line of data from one worksheet to another.
The
line of data gets added to a spreadsheet. Therefore I need to find the
keyword that moves the pointer to the first empty row to paste the data
to.
IE: keyword "next" moves the pointer to the cell to the right, I need
to move
the cell down. The keyword "end(x1down)" moves the pointer down half
page or
to the end of page.

"hecfrme" wrote:

want to edit a macro to better meet my needs. Can't locate the
keywords