I am trying to add my own lists to a workbook which uses lists.

In my case I need to add a "primary" list. The values are end_user
and application_admin

On a seperate sheet in same workbook, I have created a list with
header row primary, and two values underneath (end_user and
application_admin).

I have done the data-create list command

On another sheet, I want that list to be used to fill in cells N8 to
N83

I'll need to repeat (secondary list- values of schedule_manager and
my_teamcenter). I have the secondary list made, but cannot apply from
column O8 to )83.

Another issue with tertiary list (has about 15 values), these values
fill in column O.

The help mentioned tools-options-custom lists. I could not get the
lists I made to fill in the cells needed. I've done this before
around 2 years ago, I know I am missing something obvious. thx

jIM