Is it called 'lookup?'

  • Thread starter Thread starter mythology8
  • Start date Start date
M

mythology8

I know in Access you can have a pull-down list created from a Table, i
your form.
In Excel, you can create a list on sheet 1 (for example), and view tha
list in sheet 2 via a pull-down.
I have forgotten how to do this and would appreciate any help!
Thanks,
Ji
 
Hi

You have to define the list on Sheet1 as named range, p.e. MyList
On Sheet2, select the range you want drop-downs have in, and select from
menu Data.Validation.List
Set validation list source to
=MyList
 
Back
Top