Results 1 to 12 of 12

Kpi's sheet that Auto counts from weeks to monthly but also sorts highest to lowest

Threaded View

  1. #11
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Kpi's sheet that Auto counts from weeks to monthly but also sorts highest to lowest

    In the example if you add a row to the bottom of the sales table or change any of the data in the table, then select anywhere in the pivot table and click Data -> Refresh.

    You can automate the refreshing of the pivot table using VBA if you wish, so any change to your data is immediately reflected in the pivot table.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto sort values from highest to lowest based off of value
    By qj67 in forum Excel Formulas & Functions
    Replies: 31
    Last Post: 06-24-2014, 10:24 AM
  2. auto sort highest to lowest
    By B1G0 in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 05:37 PM
  3. [SOLVED] Line plot which automatically sorts values from lowest to highest
    By excelactuary in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-19-2013, 05:27 AM
  4. Dividing monthly values into weeks automatically (some months have 5 weeks)
    By massimoo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2012, 03:20 AM
  5. Auto Sort Values From Highest To Lowest Based Off Of Value
    By CXP2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2011, 09:15 PM
  6. Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  7. Auto sort values from highest to lowest based off of value
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-09-2008, 07:21 PM

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