Is there a way to autofill a row with alpha numeric data using data entered
in the first column. i.e.

D1 D2 D3 D4

P1234 Prog1 Prog2 Prog3 etc

Where typing P1234 will automatically fill in theneccessary operations for
that job in D2,3,4 etc