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.

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.

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.

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