I have a workbook. It has numerous rows. some of the rows are a master
identifier for rows below it. The cells below the 'master row' are empty. How
do I copy the 'master row' to 'fill' the cells for the subordinate rows
beneath it. i.e.

| 1 | abcdef | hhhhh | | |
| 2 | | | jjjjj | ppppp |
| 3 | | | kkkkk | yyyyy |

Using the above, how do I copy the cell contents from cells in row 1 to the
empty cells beneath them in rows 2 and 3? I know an easy copy and paste would
work. However; my spreadsheet has 500+ rows with multiple 'master rows'.

I attempted to use a macro; however, it copied/pasted to the same cells,
over and over.

Please help. Thanks.

My usual approach is based around data filters. Turn on the autofilter (data
/ filter / autofilter). Then use the drop-down in column A and select
"(blanks)". In the first blank cell, enter an equation to pull in the value
from the cell above (ex, if it's row 5, enter =a4). Then copy that formula
down through all the visible rows via a simple autofill. Use the drop-down
to Select All.
Repeat for subsequent columns.
--Bruce

"Otis Lamb" wrote:

I have a workbook. It has numerous rows. some of the rows are a master
identifier for rows below it. The cells below the 'master row' are empty. How
do I copy the 'master row' to 'fill' the cells for the subordinate rows
beneath it. i.e.

| 1 | abcdef | hhhhh | | |
| 2 | | | jjjjj | ppppp |
| 3 | | | kkkkk | yyyyy |

Using the above, how do I copy the cell contents from cells in row 1 to the
empty cells beneath them in rows 2 and 3? I know an easy copy and paste would
work. However; my spreadsheet has 500+ rows with multiple 'master rows'.

I attempted to use a macro; however, it copied/pasted to the same cells,
over and over.

Please help. Thanks.

Try this:

Select your range,
Hit <F5,
Click "Special",
Click "Blanks",
Then <OK
Type the equal ( = ) sign,
Hit the <UP arrow,
Hit <Ctrl <Enter.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Otis Lamb" <Otis wrote in message
...
I have a workbook. It has numerous rows. some of the rows are a master
identifier for rows below it. The cells below the 'master row' are empty.
How
do I copy the 'master row' to 'fill' the cells for the subordinate rows
beneath it. i.e.

| 1 | abcdef | hhhhh | | |
| 2 | | | jjjjj | ppppp |
| 3 | | | kkkkk | yyyyy |

Using the above, how do I copy the cell contents from cells in row 1 to
the
empty cells beneath them in rows 2 and 3? I know an easy copy and paste
would
work. However; my spreadsheet has 500+ rows with multiple 'master rows'.

I attempted to use a macro; however, it copied/pasted to the same cells,
over and over.

Please help. Thanks.