Results 1 to 2 of 2

Thread: Automatic filtering in Pivot Tables

  1. #1
    Neophyte Friedrichsen's Avatar
    Join Date
    Dec 2011
    Location
    Copenhagen
    Posts
    3
    Articles
    0

    Question Automatic filtering in Pivot Tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello

    Dunno if this is the right sub-forum.

    I need to create an automatic report system for a co-worker.

    All that person has to do is Update and print a set of predetermined reports.

    I have a set of different sets of date-intervals that i'm using. Those are Last week, Month to date and Last 4 weeks.

    Is there any way to get the pivottables to have these dates in them automatically? It's a real headscratcher, but I know the truth is outthere.

  2. #2
    Acolyte Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    80
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I have only just noticed your post and you may have an answer already.
    If not please pot an example workbook with a more detailed explanation of what you are looking for.
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

Posting Permissions

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