+ Reply to Thread
Results 1 to 1 of 1

Auto Populate based on 2 criteria using Array

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Auto Populate based on 2 criteria using Array

    Hi,

    I am currently trying to use Array function to auto populate data from Summary to Summary by Managers.
    In tab Summary by Managers, i need cell A3 to B89 auto populated based on sheet Summary.

    The state manager has to be grouped into one, non alphabetical order is fine. Sector Summary can be either sorted alphabetically or not, does not matter.

    Any help would be appreciated.

    Regards,
    Lex.
    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. How to auto populate specific data to a different worksheet based off a criteria
    By excelnewbie716 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-31-2014, 03:27 PM
  2. Auto Populate Ranges based on Criteria
    By wrasser in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-17-2014, 11:07 PM
  3. Replies: 3
    Last Post: 03-11-2014, 02:10 PM
  4. Auto Populate a list based off of certain criteria
    By finance123 in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 03:50 PM
  5. Replies: 2
    Last Post: 02-10-2012, 02:00 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