+ Reply to Thread
Results 1 to 13 of 13

data populate according to dropdown

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    data populate according to dropdown

    Hi Experts,

    I need some help on this spreadsheet, just want when I change Territory the data will auto populate from Data tab, please check screenshots and excel file.


    Thanks in Advance
    Farhan
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: data populate according to dropdown

    Here are two options, but I would go with option #2, the pivot table.
    Attached Files Attached Files
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    Hi jefferybrown, thanks for response, it is working, I just need one more thing when I select any specific address in yellow box columns then that specif address will remove from bottom list.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: data populate according to dropdown

    when I select any specific address in yellow box columns then that specif address will remove from bottom list.
    I don't really understand what this means. The attachment you posted does not have any yellow box cells and although your picture shows yellow, please describe to me with an appropriate attachment as to what you are seeking.

    With your new attachment, please use the formula I provided as you need it to work and tell what it doesn't do!

  5. #5
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    please check this attachments
    Attached Images Attached Images
    Attached Files Attached Files

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: data populate according to dropdown

    How about this...

    On the data sheet I added a helper column, column D, and on the dashboard changed the named range for address and added NA to the formula in column F (Address) with some conditional formatting.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    sorry bro it is not helping me.

  8. #8
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    sorry for waste your time, it was my mistake I have not sent correct file, this is correct file, yellow box will change by drop-box when I select any address in drop box. bottom list address will remove
    Attached Files Attached Files

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: data populate according to dropdown

    So I'm guessing you are wanting every day of the week (C11-C20, E11-E20 etc) removed from the list in B111:B4500 ?? If 4500 is correct then all those CSE formula could drag down your processing time.

    Anyway, not sure I have the right formula solution for this, but I will ask for some help

  10. #10
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    Yes jeffery now you got my point, can you please help me on this? I really need.

  11. #11
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: data populate according to dropdown

    jeffery have you checked?

  12. #12
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: data populate according to dropdown

    jeffery have you checked?
    Yes I have checked, but it appears nobody else has any suggestions. Sometimes your data is simply laid out wrong to force an over complicated formula into the structure.

    More times than not, the best way to structure your data is in a database form. When you do this it makes analyzing the data much easier.

    Example: All of the dates runs down column A, Store down column B, Address down column C etc.

    Maybe you should consider the structure and then re-ask the question. Unless somebody else jumps in, I simply don't have the solution. Sorry.

  13. #13
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: data populate according to dropdown

    No ideas so far. I am not sure I understand the instructions yet.

    I did notice there are records nearly duplicate in rows 1702 and 1720. There are also two fields in 'data' that are "Territory". I am confused. Is this a duplicate record that we may delete or can the matching Territory be clarified?

    A
    B
    C
    D
    E
    F
    1
    Territory
    Territory
    Banner
    Address1
    1702
    ON_St_Catharines
    BC - Kelowna
    OVERWAITEA SAVE ON FOODS
    3175 LAKESHORE RD
    1720
    BC_Kelowna
    BC - Kelowna
    OVERWAITEA SAVE ON FOODS
    3175 Lakeshore Rd


    I suspect this will cause problems. May we delete one of them?
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 05-24-2017, 06:35 AM
  2. Populate a table depending on dropdown data selected
    By ftrindade in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2017, 07:08 AM
  3. Populate data in a table based on dropdown criteria
    By Ragsbr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2014, 03:23 AM
  4. Help to populate cells from dropdown
    By TravisM in forum Excel General
    Replies: 1
    Last Post: 01-30-2014, 03:32 AM
  5. [SOLVED] Populate data on another sheet based on dropdown criteria from the first sheet
    By ARod0726 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2013, 01:36 PM
  6. Replies: 7
    Last Post: 06-12-2013, 07:09 PM
  7. Selecting a value from a dropdown list (data validation) which will populate cells..
    By milkychips in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2012, 09:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1