MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Function to fill missing data?

Posted by Brian on February 02, 2002 7:52 AM

On a spreadsheet I have rows that contain the following, columnar data: internal part number, description and quantity per. For each such row, I have a varying number of rows which are related to that row (immediately following that row). They contain the following data: internal part number (repeated from the "master" row), manufacturer name (in the same column as the description on the "master" row) and manufacturer part number.

I am hopeful for a means, other than copy/paste, of filling each "sub-row" with the description and quantity per as represented in the "master" row.

Grateful for any help,

Posted by John on February 02, 2002 10:11 AM

You can fill in data from rows above by:

1. Select the range of cells that you want to fill in starting with the first master row.

2. Edit -> Go To -> Special -> Blanks -> OK

3. Now, with the blanks still selected, enter an equal sign and the cell address of the first master row. So if your data is in A2:A50 and A2 is the first master row, then enter "=A2", without the quotes.

4. Press Control+Enter

The data in the blank cells should fill in with the data of the master row above it.