we use excel to list the bills that we are sending to the CPA- the CPA has
created the spreadsheet we use- and I am not sure of his methods
he created this with a cost center (column c)drop down 'pick list,' in other
words you cannot type part of it and have it autotfill the rest. You have to
drop down and hilight what needs to be filled
what i would like to do is automate many of the monthly bills
what i have to type
column a column b column c
at&t phone bill pick from dropdown list the cost center

what i would like to do is:
column a column b column c
at&t autopopulate phone bill autopopulate correct cost
center number

if the word is long enough, it will auto fill the first 2 columns

this will not owrk for all of the bills we get but would cut down
significantly and make sure we always chose the right cost center
thanks