+ Reply to Thread
Results 1 to 7 of 7

Filter pull down into different sheets

  1. #1
    Registered User
    Join Date
    08-23-2016
    Location
    Titusville, FL
    MS-Off Ver
    Office 365
    Posts
    4

    Question Filter pull down into different sheets

    Hi all. I'm trying to make a spreadsheet to keep a process organized. It's a multi-step process and here is what I had in mind:
    Page 1 is an overview of what things need to be done with a pull down of steps to be achieved: received, labeled, processed, sent, etc.
    On the following pages I would like to have the steps broken down. For example, page 1 would be titled received and when "received" is selected from the pull-down on page 1, the item would be copied from page 1 to page 2. Does that make sense? It would be like a filing system, copying items from page 1 to other pages depending on where in the process the item currently is.
    I'm not sure how to go about this. I'm completely self-taught at Excel and I've confused this teacher. LOL Anyone have any advice or can point me to a better way to describe/research what I'm trying to do?
    Thanks in advance!~

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,025

    Re: Filter pull down into different sheets

    Hi cmf456,

    To get some ideas, can you mock up an example of what you're after such as you've explained?

    It will help the forum to see what you're after.

    Just make it look like what you need with relevant notes.

    Cheers
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    08-23-2016
    Location
    Titusville, FL
    MS-Off Ver
    Office 365
    Posts
    4

    Cool Re: Filter pull down into different sheets

    Sure thing! I think this is what you want. It's a basic spreadsheet because I'm a basic gal. LOL
    But I just kinda want it to sort the items for me by their status onto separate pages.
    I've attempted to attach the excel file to this post. Thanks for any help!!
    Attached Files Attached Files

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,025

    Re: Filter pull down into different sheets

    Hi cmf456,

    Do you have any experience with MS Access?

    Trying to do what you want in Excel would require some Formulas/Functions or possibly VBA code.

    Are you familiar with the VLOOKUP Function?

  5. #5
    Registered User
    Join Date
    08-23-2016
    Location
    Titusville, FL
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Filter pull down into different sheets

    I have zero experience with MS Access. Is that what I should be using? I have used Formulas and a little on Functions in Excel, but like I said it was all self-taught and it's been years. I used to play around making macros but I'm a little rusty.
    I am not familiar with any coding. and I have not used the VLOOKUP Function although I can youtube and learn with the best of them. So, if you can point me towards what it's actually called... I can look it up. I'm at a loss however because I'm not even sure what I'm asking. LOL

  6. #6
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Filter pull down into different sheets

    I can think of how to do what you are asking, sort of. Really depends on if I understand you correctly...

    So you'd have a "master sheet" on the first page, and all of the items would have drop downs depending on their statuses. Then, depending on which status you select, it populates the correct tab with all items with that status.

    If this is the case, please check this thread and tell me if a solution along those lines is correct. I could basically populate the tabs using named dynamic ranges, and index(match()) to gather the other relevant information. I would require you to give same sample information though (fake info ofc). so we could see if it works or not.

    anyway, here is the thread, see if you are interested in something along the lines of these dynamic ranges. Think of each tab as the results when you select one of the "winners" as that would be the same basic idea.

    http://www.excelforum.com/showthread...=1#post4467192

    Going off for a while, will check on your response when I get back
    Last edited by TheN; 08-29-2016 at 09:18 AM.

  7. #7
    Registered User
    Join Date
    08-23-2016
    Location
    Titusville, FL
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Filter pull down into different sheets

    I think this is close to what I want. I've messed with it and choosing different winner/loser on first page changes the info on lists page. Would we be able to filter to multiple separate tabs from the first page? For example, the different teams could have different tabs and their game results could be filtered onto their separate page? I'm currently just using a conditional format and changing the color of the columns, but if I could use separate tabs it would be much easier.

+ 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. can you pull in filter criteria?
    By carsto in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2007, 01:29 PM
  2. Pull data - Advance Filter
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Pull data - Advance Filter
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. Pull data - Advance Filter
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] Pull data - Advance Filter
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] Pull data - Advance Filter
    By lil''bibbib in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Pull data - Advance Filter
    By lil''bibbib in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. [SOLVED] Pull data - Advance Filter
    By lil''bibbib in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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