Copy and paste up to values in last row
 

I am trying to write something that will copy data from CJ16:CO16 down to the
last row with a value in CQ16. I would like to paste this into a new sheet
(sheet two) any help?

Copy and paste up to values in last row
 

-- last row with a value in CQ16.
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
I am trying to write something that will copy data from CJ16:CO16 down to
the
last row with a value in CQ16. I would like to paste this into a new
sheet
(sheet two) any help?

Copy and paste up to values in last row
 

The three cells you mention are all on the same row.........row 16

So what do you really want done?


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 12:37:01 -0700, Scott
wrote:

I am trying to write something that will copy data from CJ16:CO16 down to the
last row with a value in CQ16. I would like to paste this into a new sheet
(sheet two) any help?