| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation when list is on a different worksheet? 2003
-- Please help, I am trying to use data validation on sheet1 but the list is on sheet 2 In sheet1 b1 column name is account code. In sheet2 colume A are Account code and sheet2 Column B are the corresponding Account names. What need to do is before I encode on Sheet1 Column C the invoice numbers I need to select first the correct account code and account name. Please help. joromajr |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation when list is on a different worksheet? 2003
You need to name the range on sheet2, InsertNameDefine..., and use that
range name in the DV. -- __________________________________ HTH Bob "joromajr" wrote in message ... -- Please help, I am trying to use data validation on sheet1 but the list is on sheet 2 In sheet1 b1 column name is account code. In sheet2 colume A are Account code and sheet2 Column B are the corresponding Account names. What need to do is before I encode on Sheet1 Column C the invoice numbers I need to select first the correct account code and account name. Please help. joromajr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create auto updating data validation list from all worksheet names | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Data validation list from another worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
