Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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,
Brian

Re: Function to fill missing data?

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.