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