Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Easy question, I think....

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select the list you have on the other sheet. You can do 1 of 2 things:

    Either type a word/name in the Name Box, top left of the work sheet, next to the '=' sign. Make the word as relivant as possible e.g. PartsList or DayOfWeek.

    Or, select the list goto Insert>Names>Define and Type the name you want.


    Next:
    Goto the sheet you want to use to select that list, highlight the column or area you need. goto Data>Validation>List (from the drop down list. then in Source type '=' and then the name of the list i.e. =PartsList. press OK.

    hope this helps
    "Have a good time......all the time"
    Ian Mac

  2. #12
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ian Mac,
    Thanks so much, I got it. Just 1 thing can you reference another .xls file instead of a sheet in the workbook?

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    NO

  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,024
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-03-27 05:53, srcurrie wrote:
    Ian Mac,
    Thanks so much, I got it. Just 1 thing can you reference another .xls file instead of a sheet in the workbook?
    No.

  5. #15
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks to all for the help.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •