Results 1 to 18 of 18

Display list depending whether cell is blank or not

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2017
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    38

    Display list depending whether cell is blank or not

    Hi, I need my worksheet to display a list which, in case any of the columns on the right are not blank, display a list of the headers which containt the non blank cells.

    Here is an example;

    Header List Asia Africa N.America S.America Europe Oceania Antartica
    Sales list1 210 12 41 2

    I'd need it to dropdown list1 with the list of headers where there have been sales (Asia, N.America, S.America and Oceania)(Please have into account that my worksheet has 10 thousand rows).

    Also, the workbook has 30 sheets with column "K" value being the sale value for that sheet country. Lets say one of the worksheets is called "Italy", I'd like the excel, in case cell "K7" of Italy worksheet is not empty, to add it to a list in a list on cell "B7" on general. Do this for as many worksheets there are, the same for other sales, check cells "K8" and add it to "B8" in general...Hope I was able to explain myself

    Any help is welcome, thanks!!
    Last edited by gonurvia; 05-03-2017 at 04:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell to display list depending on value in other cell
    By shaunguyver in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-15-2015, 07:30 AM
  2. Display text depending on one or more cell with value
    By redline24 in forum Excel General
    Replies: 6
    Last Post: 10-09-2014, 06:57 PM
  3. How to Display a comment box depending on the cell value
    By sameister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2013, 09:22 AM
  4. VBA Code - Display an Array List Depending on Date Range
    By sandonn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2013, 11:31 AM
  5. Display last text value depending on another cell
    By willia97 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2012, 01:19 AM
  6. cell display depending on date
    By djmiller in forum Excel General
    Replies: 2
    Last Post: 10-09-2008, 09:39 AM
  7. [SOLVED] display text depending on coice from drop down list
    By Calle in forum Excel General
    Replies: 11
    Last Post: 05-28-2006, 04:15 PM

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