View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?