Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formulas that return different drop down lists
I have a spreadsheet that I will be using as a data submission form that I
will send out to my suppliers, and they will send back to me once they have filled it out. I have been using data validation dropdown lists on this spreadsheet in certain cells to ensure that my suppliers submit valid values. This is kind of how I have my form set up: in cell A1, I ask the supplier to submit an account number and I use data validation to ensure the the account is valid. In A1, the valid accounts include 2 seperate set of accounts, "Balance Sheet" accounts and "Income Statement" accounts. In cell B1, I ask for sub accounts, and there are 2 sets of sub accounts, one the are valid for "balance sheet" accounts and the other for "income statement" accounts. I am trying to make it so that if you selected a "Balance Sheet" account in cell A1, you have to select a balance sheet subaccount in cell B1 and if you selected an "Income Statement" account in A1 you have to select a income statement subaccount in B1 using drop down lists. Does anyone know of a conditional formula combined with data validation that might work for this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formulas that return different drop down lists
see:
http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200721 "ads1983" wrote: I have a spreadsheet that I will be using as a data submission form that I will send out to my suppliers, and they will send back to me once they have filled it out. I have been using data validation dropdown lists on this spreadsheet in certain cells to ensure that my suppliers submit valid values. This is kind of how I have my form set up: in cell A1, I ask the supplier to submit an account number and I use data validation to ensure the the account is valid. In A1, the valid accounts include 2 seperate set of accounts, "Balance Sheet" accounts and "Income Statement" accounts. In cell B1, I ask for sub accounts, and there are 2 sets of sub accounts, one the are valid for "balance sheet" accounts and the other for "income statement" accounts. I am trying to make it so that if you selected a "Balance Sheet" account in cell A1, you have to select a balance sheet subaccount in cell B1 and if you selected an "Income Statement" account in A1 you have to select a income statement subaccount in B1 using drop down lists. Does anyone know of a conditional formula combined with data validation that might work for this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formulas that return different drop down lists
great, thanks
"Gary''s Student" wrote: see: http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200721 "ads1983" wrote: I have a spreadsheet that I will be using as a data submission form that I will send out to my suppliers, and they will send back to me once they have filled it out. I have been using data validation dropdown lists on this spreadsheet in certain cells to ensure that my suppliers submit valid values. This is kind of how I have my form set up: in cell A1, I ask the supplier to submit an account number and I use data validation to ensure the the account is valid. In A1, the valid accounts include 2 seperate set of accounts, "Balance Sheet" accounts and "Income Statement" accounts. In cell B1, I ask for sub accounts, and there are 2 sets of sub accounts, one the are valid for "balance sheet" accounts and the other for "income statement" accounts. I am trying to make it so that if you selected a "Balance Sheet" account in cell A1, you have to select a balance sheet subaccount in cell B1 and if you selected an "Income Statement" account in A1 you have to select a income statement subaccount in B1 using drop down lists. Does anyone know of a conditional formula combined with data validation that might work for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up conditional drop down lists in Excel 2003? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
formulas and drop down lists | Excel Worksheet Functions | |||
Conditional Drop Down Lists | Excel Discussion (Misc queries) | |||
Conditional drop-down lists | Excel Worksheet Functions |