| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you make a drop down box with info from another page?
I need to make each box have information from different paragraphs from
sheets in the same file. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you make a drop down box with info from another page?
Not quite sure what you mean by "paragraphs": perhaps an example would help.
"Katie" wrote: I need to make each box have information from different paragraphs from sheets in the same file. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you make a drop down box with info from another page?
The sheets have no numerical value. It is a safety report with only words.
"Toppers" wrote: Not quite sure what you mean by "paragraphs": perhaps an example would help. "Katie" wrote: I need to make each box have information from different paragraphs from sheets in the same file. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you make a drop down box with info from another page?
On Jul 13, 1:18 pm, Katie wrote:
The sheets have no numerical value. It is a safety report with only words. "Toppers" wrote: Not quite sure what you mean by "paragraphs": perhaps an example would help. "Katie" wrote: I need to make each box have information from different paragraphs from sheets in the same file. Name the group of data i.e. data is in sheet 2 cells A1:A20 Name that group of cells by highlighting them and then in the3 cell reference box (where you would see the name of each cell e.g A1 ) type in a name. That group of cells can now be reference by the given name from any sheet. Now go to the cell in the other sheet you want to create the drop menu. On the menu bar select Data - Validation For the Allow criteria select List For the Source type in =the_name_you_gave_your_grouped_cells Done Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| click/unclick a box and make other info. appear? | Excel Worksheet Functions | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| put info from a drop down box into another sheet | Excel Discussion (Misc queries) | |||
| Drop down to diplay info from another sheet | Excel Worksheet Functions | |||
| how do i make one chart that my ees can input info, and have a se. | Excel Worksheet Functions | |||
Hybrid Mode
