I have developed a 10 row cable spreadsheet. Each row is specific to one type of cable (CAT5, CAT6, Shielded Cable, etc.). All I need to do is choose the type of cable needed, enter the footage in column A, and columns B.C.D.& E of that row auto fill.

I now need to designate one specific row on another spreadsheet, that will auto fill the information from any row I choose in the cable spreadsheet. Is this possible?