| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy range and paste into every 3rd cell of new range
I have 2 worksheets and I am looking for a macro that will copy a range of
cells from one worksheet, then paste them to another worksheet, but leave 2 blank cells between each cell. sheet to copy from "MON" range: A7:A80 sheet to paste into "MON LOG" starting at cell A5, paste then leave 2 cells blank, next cell A8, etc. until all of the copied range A7:A80 has been pasted. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy range in macro using paste special values | Excel Discussion (Misc queries) | |||
| copy/paste won't refer to the appropriate range of cells | Excel Discussion (Misc queries) | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
| CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
Threaded Mode
