Copy values to another worksheet

[juniper622]

Is there a way to select several non-adjacent cells and the copy th
values to the next available row in another worksheet automatically
with a macro perhaps? I can't seem to be able to find a way to impor
to the next available empty row

 

[David McRitchie]

You can probably do that with a macro, but you are too skimpy
on the details. In order to write code you have to know exactly
what you are working with. As far as the next available row
according to content in column A the following code will illustrate
what you can use. Of course you try to avoid actually selecting
a cell within a
macro.

for column A
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select

for the column of the active cell
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Offset(1, 0).Select

--

 

[Ron de Bruin]

Hi juniper622

Try this
http://www.rondebruin.nl/copy1.htm