+ Reply to Thread
Results 1 to 5 of 5

Pivot Table date range out of order

  1. #1
    Registered User
    Join Date
    03-01-2007
    Posts
    37

    Pivot Table date range out of order

    I keep running into this problem see attached as an example. I've tried to format the cells as General and Numbers with the same result.
    Attached Files Attached Files
    Last edited by GeoGreco; 03-07-2007 at 12:21 PM.

  2. #2
    Registered User
    Join Date
    03-01-2007
    Posts
    37

    Would a function work?

    Would a dateValue function work i tried a few different formula but to no avail

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sorry but what's the problem

    Do you want to Group by Month ??

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Registered User
    Join Date
    03-01-2007
    Posts
    37
    Yes, in the order as per the date range on the spreadsheet

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    You could either use a helper column with a lookup e.g say left(A1,3) = Jan then it would return 1 etc

    or as it's a short list just right click say JUL 06 REB BAL and select order and move as required then preserve the formatting

    http://www.contextures.com/xlfaqPivot.html#FormatLost

    VBA Noob

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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