| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy paste values macro | Excel Discussion (Misc queries) | |||
| Copy Values only without Paste Special | Excel Discussion (Misc queries) | |||
| Macro for copy and paste values | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy-paste as Values automatically | Excel Worksheet Functions | |||
Linear Mode
