Results 1 to 2 of 2

Create Autoupdate Table/Pivot that sorts by colour or data source order

Threaded View

KateMaz Create Autoupdate Table/Pivot... 05-13-2019, 05:02 PM
GeoffW283 Re: Create Autoupdate... 05-13-2019, 06:02 PM
  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Create Autoupdate Table/Pivot that sorts by colour or data source order

    Hey

    Please can someone help!

    I have some data based on whether a check box is checked or not. (See attached screenshots).

    If it is checked at level 3 it enters into a table that is coloured by the difficulty of the task, if it isn't checked it doesn't feed through/show and leaves as a blank cell.

    I then need a table which auto updates when refreshed (so I thought Pivot table) but the pivot table won't allow me to sort by data source order or by colour, is there any other way for me to do it so that the data shows in the correct order?

    Many thanks in advance

    Kate
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create Range from highlighted cells for Pivot Table Source Data
    By athyeh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2015, 03:34 PM
  2. Excel 2010 Pivot Table - Create Macro to update source data
    By swaza in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-29-2015, 06:59 AM
  3. [SOLVED] create more than one pivot table from the same data source
    By ethelp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-07-2014, 02:29 PM
  4. 2010 Pivot Table Sorting The Same Order As Data Source
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2012, 05:47 PM
  5. Access Create Excel Pivot Table Data Source
    By ddecost2@gmail.com in forum Excel General
    Replies: 0
    Last Post: 07-12-2006, 04:40 PM
  6. Create Pivot Table with 2 different Data source
    By cheerboy555 in forum Excel General
    Replies: 1
    Last Post: 04-30-2006, 09:55 AM
  7. [SOLVED] Pivot Table Report formatting - can't select Data Source Order
    By Becky in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 02:05 PM

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