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,