Results 1 to 2 of 2

Thread: Macro to filter and copy data from all sheets except 3
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,318
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Macro to filter and copy data from all sheets except 3

    Hi Everyone,

    I need some help,
    I have a document with 3 tabs that are always there and weekly tabs that get added
    now the 3 tabs are "Template", "Todo List", and Historic.

    now the other tabs are all the same and get created from the "Template" tab but I never know what they will be called or how many sometimes it just one, other time it can be 30+

    so heres what I need

    I want a macro that will go to every sheet one at a time (excluding
    "Template", "Todo List", and Historic.) and create a filter for Columns C17 to H & last row.
    Column H has True and False in it I want to show the False rows
    Now column C is a date row and I want all dates that are one week in the future or before that.


    So basically goto sheet filter
    Columns C17 to H & last row (row 17 are my headers)
    Filter by Column H show "False"
    Filter by column C all dates that are less than today +7 days

    then copy this filtered data Columns C:H (if there is any) and paste it in the "Todo List" sheet first free row after cell H20.

    so what i get is a Todo list sheet showing all the rows that where false and within the dates

    please help if you can

    Thanks

    Tony







  2. #2
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,318
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to filter and copy data from all sheets except 3

    Bump

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •