copy every 3rd row to empty rows below

A

Annette(Omaha)

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

Jim Thomlinson

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

Annette(Omaha)

This worked great! Thank you Jim

Jim Thomlinson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy several row headers to rows (blank) below for each header 1
How do I insert a row after every row of data in XL? 5
My spreadsheet in some cases automatically adds a row below how? 5
Help on Macro to hide empty rows 4
Using one row, how do I fill the row below (numerous times)? 2
Deleting/removing unused rows in a worksheet 3
Filling an empty row with the data in row above it 2
Insert Cells every other row 1

Top