Copy and paste up to values in last row

S

Scott

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?
 
G

Gord Dibben

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
 
Top