+ Reply to Thread
Results 1 to 3 of 3

Search name manager data set within another set

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    14

    Search name manager data set within another set

    Hi all,

    I have two name manger data sets that I'd like to search within itself. Example being I have 45 "Blocks" outlined within the sheet. Each block has its own Name Manger set, I also have a much larger data set that refers to the "Modules" distributed to the site. That is broken down into 3 separate Name Manager sets. I want the main search to be within the "Block" (which will give the value of 80) but within that 80 value, find the "Module" amounts within the confines of the Block.

    The best I can think of is what's below:

    =CountCellsByFontColor(Module!Block_01,B87),(Module_430w,B87)

    Any suggestions or help regarding this would be greatly appreciated.

    If I haven't made myself clear enough, I will try to reply with a better breakdown but I think this tell everyone what it is I need.

    Cheers,

    Shonky

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,500

    Re: Search name manager data set within another set

    I would suggest attaching a much simplified example workbook (see yellow banner) with maybe 5-8 blocks and explain what where and why you'd like the answer to be.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    08-18-2019
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    14

    Re: Search name manager data set within another set

    Here's the sheet, apologies for that.
    Attached Files Attached Files

+ 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. [SOLVED] Name Manager and Data Validation Lists
    By Janet_824 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2018, 06:29 PM
  2. sales manager & purchase manager sheets command button error
    By rana19 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-24-2016, 07:26 AM
  3. Data Manager for R&D Department
    By CRinne in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-21-2013, 09:08 PM
  4. [SOLVED] Pulling data from one workbook to another based on Manager name
    By tidjy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2013, 04:25 AM
  5. Find the Highest Manager from 2 columns of Data
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2010, 07:16 PM
  6. Data Name Manager Problem
    By hifliers in forum Excel General
    Replies: 4
    Last Post: 05-15-2009, 02:26 AM
  7. [SOLVED] About Data Table & Scenario Manager.
    By JOBY JOHN NEERIYANKAL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-19-2006, 10:35 AM

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