Please help!! - Copy cell to next row in different worksheet

[Ritz]

I need to copy cell AA3 to (NextRow, 4) in a different worksheet. How do I do that? I'm actually copying several different cells, however all of the other cells are on the Target Row and this is the entry I used to copy them (which works well)

Cells(Target.Row, 54).Copy Destination:=.Cells(NextRow, 5)


HELP!!!!

 

[Ritz]

Re: Please help!! - Copy cell to next row in different works

Here is what I'm currently using, however it moves the cursor to select the cell AA3 and I have to reposition it again and again to the row I'm actually working on.

Range("AE3").Select
Selection.Copy Destination:=.Cells(NextRow, 4)

 

[Damon Ostrander]

Re: Please help!! - Copy cell to next row in different works

Hi *******s,

Unless you need to copy the formats of the cell as well as the contents, it is easier to just transfer the contents without changing the selection:

.Cells(NextRow,5) = Cells(Target.Row,54)

Damon

 

[Ritz]

Re: Please help!! - Copy cell to next row in different works

.Cells(NextRow,5) = Cells(Target.Row,54)

This won't work, as the cell I'm needing to copy isn't in the target row. Targer.Row, 54 was just an example of what I'm using for my other information.

It's cell AA3 on a different (header) row that I'm needing to copy.

 

[Damon Ostrander]

Re: Please help!! - Copy cell to next row in different works

Hi again *******s,

In that case, how about

.Cells(NextRow,5) = Range("AA3")

Of course, you must have a With statement that qualifies the destination worksheet, and the source worksheet is the active worksheet.


Damon