How do you make a drop down box with info from another page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make each box have information from different paragraphs from
sheets in the same file.
 
The sheets have no numerical value. It is a safety report with only words.
Click to expand...

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
 
Back
Top