| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying every other row
Hi,
Starting in cell C16 I need to copy every 3rd cell in column C until there is no more data. How do I copy cell C16 , offset down 2 cells, copy again etc etc until blank. I then need to paste all these values into column C of another worksheet ("LFmacro.xls" sheet name "report") - BUT this worksheet already has data in it so would need to paste into the next blank row (or leave a blank row and paste into the next would be useful) Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying row to row | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| TextBox copying not like windows copying, heh? | Excel Programming | |||
| Copying | Excel Programming | |||
| Copying data down to next dirty cell, then copying that data | Excel Programming | |||
Threaded Mode
