I Have data in columns
AD AE AF AG (will be used for final scores)
1001 DEN -4
1002 STL 4
1003 DENO 46
1004 DENU 46
1005 BUF 10
1006 NE P -10
1007 NEPU 41
1008 NEPO 41
I want to set it up so that I can click on a cell in column C and it will open a drop down list and it will insert the above data in column C, D, and E.
If I click on 1001 it will insert 1001 in C, DEN inD, and -4 in E.
If this cant be done what is the best way to do what I am trying to do.
Thanks for any help.
irenesboy
AD AE AF AG (will be used for final scores)
1001 DEN -4
1002 STL 4
1003 DENO 46
1004 DENU 46
1005 BUF 10
1006 NE P -10
1007 NEPU 41
1008 NEPO 41
I want to set it up so that I can click on a cell in column C and it will open a drop down list and it will insert the above data in column C, D, and E.
If I click on 1001 it will insert 1001 in C, DEN inD, and -4 in E.
If this cant be done what is the best way to do what I am trying to do.
Thanks for any help.
irenesboy