Results 1 to 11 of 11

Filter worksheet by lists

Threaded View

brainzlp Filter worksheet by lists 07-29-2015, 09:51 AM
Bernie Deitrick Re: Filter worksheet by lists 07-29-2015, 11:38 AM
brainzlp Re: Filter worksheet by lists 07-29-2015, 03:11 PM
Bernie Deitrick Re: Filter worksheet by lists 07-29-2015, 03:58 PM
brainzlp Re: Filter worksheet by lists 07-29-2015, 04:02 PM
brainzlp Re: Filter worksheet by lists 07-29-2015, 04:39 PM
  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Filter worksheet by lists

    Hello community, hope you can help me with this

    I have the hard part infront, which is difficult to express by words what i have.
    Hope you can understand what i'm needing.

    I need to use some specific filters In sheet ("Tapasois") and then place the total quantity into a cell in Sheet "RESUMO".

    I think i have to use 3 lists:
    List of brands: Seat,Citroen, Peugeot, Audi, etc (More will be added later)
    List of bubbles: B6,B7 (Later will be added more if needed)
    List of width: 60,70,80,90,99 (which can be added more later)

    I need to filter my sheet"tapasois" by Brand SEAT only, Then B6 , then 60 and take that total quantity into a cell. then
    FILTER BY 70 and place in 3 cells to right
    filter by 80 and place 3 cells to right
    etc etc till 90
    Then Filter SEAT but in "B7" Then measures again and place in the row below.
    After all measures i'll pass to:
    Citroen witch is the next in list.
    Citroen b6 than measures
    Citroen b7 than measures

    After that go to peugeot (next on list)
    Peugeot b6 than measures
    peugeot b7 than measures

    Than place everything in the right cell in Sheet ("RESUMO")

    I've done manually for the first rows in Resumo:

    
    'PREENCHIMENTO DA LINHA SERIGRAFIA B6 CRU
    'Filtrar "tipo de impressão" para C) SERIGRAFIA"'
    Range("A:AW").AutoFilter field:=13, Criteria1:="C) SERIGRAFIA"
    
    Range("A:AW").AutoFilter field:=21, Criteria1:="B6"
    
    Range("A:AW").AutoFilter field:=23, Criteria1:="60"
    
    If Worksheets("Tapasois").Range("T" & Rows.Count).End(xlUp).Value = Empty Then
        Worksheets("RESUMO").Range("B8") = Empty
    Else
        Worksheets("RESUMO").Range("B8") = Worksheets("Tapasois").Range("T" & Rows.Count).End(xlUp)
    End If
    Hope you can help me out with this, cuz in future it's easy, just have to add on list, otherwise i'll have to be programming soon as another brand comes.
    Attached Files Attached Files
    Last edited by JBeaucaire; 07-29-2015 at 10:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. One filter/ Master filter multiple pivot tables based on worksheet...
    By jlworden in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-10-2013, 11:16 AM
  2. Filter Lists
    By HangMan in forum Excel General
    Replies: 4
    Last Post: 01-12-2013, 07:37 AM
  3. Using Drop Down lists - how to filter?
    By setmoa in forum Excel General
    Replies: 7
    Last Post: 07-01-2012, 03:40 PM
  4. To filter out lists depending on heading
    By kmlprtsngh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 04:58 PM
  5. Filter Two lists (multiple columns)
    By ebbo in forum Excel General
    Replies: 3
    Last Post: 03-17-2010, 07:09 AM
  6. Drop Down Lists Filter Out rows
    By james.benham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2009, 06:35 AM
  7. Filter arrows on drop down lists
    By HRman in forum Excel General
    Replies: 0
    Last Post: 04-05-2006, 05:10 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