I want to know how to type a number from 1-27 in a cell and have it
automatically put in numbers in that cell and one other cell off of another
sheet in the workbook.

Example: If I type in 1 in D3, it would automatically enter 4-3 1/2" in D3
and 4-400KCMIL in E3. If I type in 5, it would automtacially enter 2 1/2" in
D3 and 6-250 KCMIL in E3.

THANKS!!!