+ Reply to Thread
Results 1 to 3 of 3

Auto populate sheet based on validation criteria from master

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    California
    MS-Off Ver
    Excel 2011
    Posts
    2

    Auto populate sheet based on validation criteria from master

    Ok, I can't quite get this figured out. I am trying to auto populate data in one sheet using a dual column criteria from a master sheet. I have attached an example. In this example I would like to take all rows that meet the criteria of say "Cowart" in column E when the criteria of say "Progressing" is also met in column C in that same row. If those two criteria are met I want to auto populate that entire row of data to the 2nd sheet labeled progressing.

    Any help is greatly appreciated. If I am pointed in the right direction I should be able to figure it out if given an example. Thank you in advance for any and all help!
    Attached Files Attached Files
    Last edited by Hydro215; 02-10-2012 at 05:59 PM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Auto populate sheet based on validation criteria from master

    Hi and welcome to the forum

    One way to do this, is using IF(AND functions and then Auto filter.

    You put the same(almost)formula in second row and then copy down.

    In A2:

    =IF(AND('Global List'!C2="Progressing";'Global List'!E2="Cowart");'Global List'!A2;"")

    Then you use Auto Filter.

    Hope to helps you.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    California
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Auto populate sheet based on validation criteria from master

    Ok, I get it thank you. However I am not not having luck doing this in Google Docs....darn google. I can reproduce it as I wish in Excel though. Thank you for your help! I have to hunt down this type of task in the google docs world.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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