| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a list base on another worksheet
hello community
is there a way to create a data list basing on another worksheet data ? can somebody please help me on this thanks oldLearner57 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a list base on another worksheet
Create a named range on the other sheet
Enter that name as list reference in Validation box HTH -- AP "tikchye_oldLearner57" a écrit dans le message de news: ... hello community is there a way to create a data list basing on another worksheet data ? can somebody please help me on this thanks oldLearner57 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a list base on another worksheet
I used your recommendation but when I enter the Range name (from another
worksheet), i got a prompt telling me that the Validating list must be from the active worksheet ? can please assist further thanks :) -- oldLearner57 "Ardus Petus" wrote: Create a named range on the other sheet Enter that name as list reference in Validation box HTH -- AP "tikchye_oldLearner57" a écrit dans le message de news: ... hello community is there a way to create a data list basing on another worksheet data ? can somebody please help me on this thanks oldLearner57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create 3 list boxes dependent on prior selections | Excel Discussion (Misc queries) | |||
| list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
| Using VBA to create a new worksheet, and then target new worksheet | Excel Discussion (Misc queries) | |||
| Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions | |||
| How to create a fill down that increments based on the worksheet n | Excel Worksheet Functions | |||
Hybrid Mode
