Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
I need some help.
Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Hi ,
Take a look to Debra web http://www.contextures.com/xlDataVal02.html#TwoWord "djs" wrote: I need some help. Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Debra Dalgleish shows how you can achieve your first requirement he
http://www.contextures.com/xlDataVal02.html As for your second query, have you tried highlighting the data and using Data | Sort ? You can sort on up to 3 fields of data (columns) and choose ascending/descending order for each of those fields. Hope this helps. Pete On Jan 21, 5:01*pm, djs wrote: I need some help. Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? *e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Thanks guys.
Will let u know how it works out for me "Pete_UK" wrote: Debra Dalgleish shows how you can achieve your first requirement he http://www.contextures.com/xlDataVal02.html As for your second query, have you tried highlighting the data and using Data | Sort ? You can sort on up to 3 fields of data (columns) and choose ascending/descending order for each of those fields. Hope this helps. Pete On Jan 21, 5:01 pm, djs wrote: I need some help. Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
It worked great Eduardo and Pete. Thanks alot for the tips.
I just have one more question: How can I make it that when I select something from a drop down list in B2 Cell D2 would have the correct answer. e.g. A2 - Dept. Heads is selected from list. B2 - Production. C2 would have the name of the production Manager. Hope someone can help me with this one. djs... "djs" wrote: Thanks guys. Will let u know how it works out for me "Pete_UK" wrote: Debra Dalgleish shows how you can achieve your first requirement he http://www.contextures.com/xlDataVal02.html As for your second query, have you tried highlighting the data and using Data | Sort ? You can sort on up to 3 fields of data (columns) and choose ascending/descending order for each of those fields. Hope this helps. Pete On Jan 21, 5:01 pm, djs wrote: I need some help. Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Debra's site also shows how you can have a third dependent drop-down,
but if you only have one Production Manager then you can use VLOOKUP - Debra gives full details on her site. Hope this helps. Pete On Jan 21, 9:57*pm, djs wrote: It worked great Eduardo and Pete. Thanks alot for the tips. I just have one more question: How can I make it that when I select something from a drop down list in B2 Cell D2 would have the correct answer. e.g. A2 - Dept. Heads is selected from list. B2 - Production. C2 would have the name of the production Manager. Hope someone can help me with this one. djs... "djs" wrote: Thanks guys. Will let u know how it works out for me "Pete_UK" wrote: Debra Dalgleish shows how you can achieve your first requirement he http://www.contextures.com/xlDataVal02.html As for your second query, have you tried highlighting the data and using Data | Sort ? You can sort on up to 3 fields of data (columns) and choose ascending/descending order for each of those fields. Hope this helps. Pete On Jan 21, 5:01 pm, djs wrote: I need some help. Ive got a very large woork sheet and would like ot break it down so I dont have to do alot of typing. Here is what I would like to know if its possible. 1. Ive created a number of Dropdown list, but wanted to know if when I selected a particular item from from list in cell B2 cell D2 would automatically be populated by the correct list? *e.g. Department Heads are selected in B2 only the pre-assinged names would appear in a drop down list in cell D2. and so forth. 2. How do I do a sort by text or would I need to put a number infront of the text for it to work. eg. Say I had a sheet of 1000 employess by department, positions,yrs of service and so on. How could I sort out only the Department Heads or say job lvls? Ive tried many different formulas but they would work for part but not all. Help would be greatly appreciated.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
excel formulas | Excel Worksheet Functions |