MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 576|Reply: 11

Display a named range of cells each time a selection from a

[Copy link]

15

Topics

80

Posts

197

Integral

Conqueror

Rank: 3Rank: 3

Integral
197
Post on 2-11-2017 05:57:50 | All posts |Read mode
Each time I select a different company from a drop-down list, I want to display a named range of cells that is specific to that company. Would appreciate any assistance  have attached a sample file.
Thanks in advance








  • TestFile.xlsx
    (13.3 KB, 4 views)
    Download








  • Reply

    Props Report

    0

    Topics

    615

    Posts

    1422

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1422
    Post on 2-11-2017 06:15:45 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 09:22:28 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 4 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 10:27:51 | All posts



    Perfect! Thanks so much Andy.
    Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 11:53:27 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 6 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 15:36:37 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 11 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 15:57:39 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 14 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 17:56:39 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 16 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 19:44:11 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 18 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 21:13:59 | All posts



    one way is to use the INDEX function.
    You will need 1 cell with a Match function to locate top left corner of company data.








  • 1173503.xlsx
    (13.5 KB, 20 views)
    Download















  • Reply Support Opposition

    Props Report

    12Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-18-2017 09:01 , Processed in 0.294670 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!