| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy every 3rd row to empty rows below
I have an Excel 2003 spreadsheet that has data in every 3rd row, and this
data needs to be copied to the 2 blank rows below the rows with data. I need help creating a macro to complete this task. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 3rd row to empty rows below
You don't really need a macro. Select the entire column. Hit F5 - Special
Cells - Blanks - Ok. All of the blanks will be selected. Type = and then hit the up arrow to refrence the cell above. Hit Ctrl+Enter. The formula is now in all of the blank cells. Copy and paste special values and you are done. If you want you can record a macro while doing this to get a start on an automated solution. -- HTH... Jim Thomlinson "Annette(Omaha)" wrote: I have an Excel 2003 spreadsheet that has data in every 3rd row, and this data needs to be copied to the 2 blank rows below the rows with data. I need help creating a macro to complete this task. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 3rd row to empty rows below
Examples of layout and before/after
-- Don Guillett Microsoft MVP Excel SalesAid Software "Annette(Omaha)" wrote in message ... I have an Excel 2003 spreadsheet that has data in every 3rd row, and this data needs to be copied to the 2 blank rows below the rows with data. I need help creating a macro to complete this task. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 3rd row to empty rows below
This worked great! Thank you Jim
"Jim Thomlinson" wrote: You don't really need a macro. Select the entire column. Hit F5 - Special Cells - Blanks - Ok. All of the blanks will be selected. Type = and then hit the up arrow to refrence the cell above. Hit Ctrl+Enter. The formula is now in all of the blank cells. Copy and paste special values and you are done. If you want you can record a macro while doing this to get a start on an automated solution. -- HTH... Jim Thomlinson "Annette(Omaha)" wrote: I have an Excel 2003 spreadsheet that has data in every 3rd row, and this data needs to be copied to the 2 blank rows below the rows with data. I need help creating a macro to complete this task. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell contents in empty rows below it till any unempty row com | Excel Discussion (Misc queries) | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
Linear Mode
