+ Reply to Thread
Results 1 to 10 of 10

Generating a list from rows on different sheets excluding blanks

  1. 02-05-2016, 01:54 PM #1
    max8719
    max8719 is offline
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Exclamation Generating a list from rows on different sheets excluding blanks

    Sales Day Tracker.wip.xlsx

    Good day Excel Pro's,

    I have attached my spread sheet for convenience.

    What I am having difficulty with is pulling all company names from the sheets into list formats on the data sheet.

    I have company names that occur in cells

    C5:Q5
    C14:Q14
    C23:Q23
    C32:Q32
    C41:Q41
    C50:Q50
    C59:Q59
    C68:Q68

    I will be putting 52 sheets in there which would represent 1 week of the year. Attached is just the first 3 months.

    There are 2 lists, 1 which pulls client names that have been called and 1 which would pull through client names that have a "yes" in the converted cell.

    Ideally I would prefer to use formulas to achieve this but VBA is an option I would not turn down.

    Thanks in advance for you support.
    Reply With QuoteRegister To Reply
  2. 02-05-2016, 03:41 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Generating a list from rows on different sheets excluding blanks

    Use a macro. Change your Sheet1 name to "Client Names" (without the quotes), and run this.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 02-06-2016, 12:31 PM #3
    max8719
    max8719 is offline
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Re: Generating a list from rows on different sheets excluding blanks

    That works great. Thanks

    I have added another sheet called Dashboard into the workbook and want the macro to exclude pulling information from this sheet. Please can you guide me how to do that?

    Thanks for your support
    Last edited by max8719; 02-06-2016 at 01:33 PM.
    Reply With QuoteRegister To Reply
  4. 02-06-2016, 01:39 PM #4
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Generating a list from rows on different sheets excluding blanks

    change

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-06-2016, 02:37 PM #5
    max8719
    max8719 is offline
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Re: Generating a list from rows on different sheets excluding blanks

    I can't seem to get it to work properly.

    The client names sheet has been renamed to overview.

    I have added another list for clients visited, If there are any clients have a "yes" in the visited cell, I would like there name pull through too.

    Again thanks for helping
    Attached Files Attached Files
    Last edited by max8719; 02-07-2016 at 09:46 AM.
    Reply With QuoteRegister To Reply
  6. 02-06-2016, 02:55 PM #6
    max8719
    max8719 is offline
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Re: Generating a list from rows on different sheets excluding blanks

    I forgot to mention there is also a data sheet which is very hidden, which I am using formulas for to pull figures into the thermometers.
    Last edited by max8719; 02-06-2016 at 03:38 PM.
    Reply With QuoteRegister To Reply
  7. 02-06-2016, 03:43 PM #7
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Generating a list from rows on different sheets excluding blanks

    Change:
    Please Login or Register  to view this content.
    to 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 02-06-2016, 04:07 PM #8
    max8719
    max8719 is offline
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Re: Generating a list from rows on different sheets excluding blanks

    Thanks that works .

    If I wanted to generate a list for the name of clients visited using the yes condition above the converted rows. How would I edit the code to pull through that list into comuln C in the overview sheet?

    Please Login or Register  to view this content.
    This will be to complete.

    Many Thanks,
    Last edited by max8719; 02-06-2016 at 04:10 PM.
    Reply With QuoteRegister To Reply
  9. 02-08-2016, 11:23 AM #9
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Generating a list from rows on different sheets excluding blanks

    You may need to post an example workbook (not sure what 'above the converted row' means) but if you mean one row above the rows that had the 'yes' we were checking for before, try


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 02-08-2016, 11:25 AM #10
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Generating a list from rows on different sheets excluding blanks

    Sorry, I replied to the wrong message after copying something....


    You may need to post an example workbook (not sure what 'above the converted row' means) but if you mean one row above the rows that had the 'yes' we were checking for before, try


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Extract a List Excluding Blanks
    By chotosiete in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-16-2019, 05:47 AM
  2. [SOLVED] Extract a list from a column - excluding blanks
    By bungaree in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-17-2015, 03:48 AM
  3. [SOLVED] Generate new sheets from a list and use a template sheet only when generating.
    By Daril_Ghiroza in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2015, 10:00 AM
  4. [SOLVED] Formula to Alphabetize A List, Excluding Blanks
    By JYTS in forum Excel General
    Replies: 4
    Last Post: 11-03-2015, 05:57 PM
  5. [SOLVED] Create a list of uppercase data from a range excluding blanks and errors
    By PAexcel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-17-2014, 01:32 PM
  6. [SOLVED] Function To Build A List For A Drop Down, Excluding Blanks And Non-Matches.
    By GEANZ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2013, 11:35 PM
  7. Linking List While Excluding Blanks
    By hgb in forum Excel General
    Replies: 5
    Last Post: 04-26-2011, 03:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1