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.
|