Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste every x number of cells
So I think I am stuck and need some help.
I have a list of numbers and want to duplicate a number every so many cells keeping the duplicate in the list. I have figured out how to insert 2 blank lines every 20 cells but now need to copy the cell after the blank cells and paste it into the first blank cell i.e I have inserted 2 blank cells at A10 and A11 moving the list down, now I want to copy the contents of cell A132 (the old A10) and paste it in the blank A10. I am sure there is an easy way to do this but I am stuck€¦.any help would be great! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
Copy and Paste Number from Notepad | Excel Discussion (Misc queries) | |||
How to copy and paste number formats only? | Excel Programming | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) |