+ Reply to Thread
Results 1 to 2 of 2

Dynamic formula to aggregate "investor"-specific data listed across multiple "Deal" sheets

  1. #1
    Registered User
    Join Date
    02-24-2016
    Location
    Atlanta, GA
    MS-Off Ver
    2016
    Posts
    2

    Dynamic formula to aggregate "investor"-specific data listed across multiple "Deal" sheets

    I have a workbook in which I have created "Investor" and "Deal" templates that will be used to manage deal specific data, but that also aggregate client data across all 'deals' so that all relevant client communication is captured on their specific tab.

    The folder contains a master "Index" tab that dynamically returns the list of sheet/deal/investor names. There are also blank Title Sheets that will be used to help sort the investor/deal templates into categories.

    I would like to have it so that as an "Investor" is selected from the "Capital Source" dropdowns starting in Row 47 on the ."Deal Template" sheet, that the Deal Name in cell (D9) will be returned to the appropriate "Investor Template" sheet (starting at Row 41), along with the corresponding Investor's Notes from the Deal Template (starting at S47).

    Is there a way (not fully opposed to macros, but need it to be as non-volatile as possible), to have the Investor Sheet automatically find it's name across all Deal Template "Capital Source" ranges, and return the corresponding Deal Name and Notes to the Investor Sheet?


    ...Subsequent other "Deal" and "Investor" sheets/tabs will be added as new "deals" or investor relationships materialize -- (Deals will be sorted after the DEALS>> title sheet, and Investors after their appropriate category). I had thought there may be a way to start an INDEX/MATCH/COUNTIF formula range that spans DEALS>>:END, but was unsure how to make it work.

    Any help would be greatly appreciated!!!
    Last edited by BACPHunter; 02-26-2016 at 10:33 AM.

  2. #2
    Registered User
    Join Date
    02-24-2016
    Location
    Atlanta, GA
    MS-Off Ver
    2016
    Posts
    2

    Re: Dynamic formula to aggregate "investor"-specific data listed across multiple "Deal" sh

    test to check posting error...

+ 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] SELECT query to deal with "A " and "The " prefixes
    By mc84excel in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-10-2014, 09:51 PM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. Replies: 5
    Last Post: 09-19-2008, 04:02 PM
  7. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

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