Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User selection for pivot table (excel 97)

    Hi there,
    I wonder if the following is possible. I have a pivot table with different months to be summarised, but I want the user to choose which specific month he wants. ie: the column has a field called color, the row has a field called model, and the data block has sum of "whichever month the user wants" (all the months are available in the worksheet. I herewith attach a small example of what I mean. Unfortunately I cannot change the layout of my worksheet as I bring it in like this from SAP Business Wharehouse.

    Thanks a lot
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: User selection for pivot table (excel 97)

    Hi Rene

    Ideally the data should be organised differently to achieve what you want, but if you cannot change the existing set up the following approach should work.

    You could use a combo box pointing to a list of months (in a column) and as the user selects a month, the value is placed in a linked cell, which can then be accessed by you macro to select the required month. I don
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User selection for pivot table (excel 97)

    Hi Andrew,
    You are a super star lounger, thanks a million.

Posting Permissions

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