Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need excel to do mutiple functions per row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need excel to do mutiple functions per row
You may want to have a dropdown list for the A column names and VLOOKUP for
filling the B and C columns from a table. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Thu, 14 Jun 2007 11:32:01 -0700, petlover wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutiple Excel Windows. | Excel Discussion (Misc queries) | |||
print page seprator for mutiple copies in excel is not working | Excel Discussion (Misc queries) | |||
mutiple regression help | Excel Discussion (Misc queries) | |||
how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions |