Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Thumbs up Unanswered: Functions within a pivot table



    I have a pivot table... i need a function that will allow search and sort of this table.

    For example... if i have various expenses within this table, how is it possible to search for particular expense pay dates? - be able to search for particular upcoming payments for bills for example.

    Is there also a possbility of having an alert within the pivot table... be alerted for upcoming payments?

    Your advice/ suggestions/ tips and answers are much appreciated

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    i reckon youll need VBA for this how do you want alerts to appear and how would you like to search

    How is the particular pivot used
    can people change it
    do you want a textbox to type your search criteria in
    do you want upcoming payments to be highlighted put into a new sheet etc.

    anything else you can think of

    we will have to handle a lot of things if you want the code to handle everything that can happen

    do you also know that if you double click on some data in the pivot table it will produce a list from the datasource that built that calculation

    Dave

  3. #3
    Join Date
    Mar 2005
    Posts
    4

    Thumbs up

    Dave thanks for this...

    The Pivot-table that i have created allows data to be di-sected into new sheets...

    I would like the alerts to identify upcoming payments to be made - everytime the worksheet is opened.. the script would run and look for the closest payment to be made...

    The pivot-table is changable by all... it is to be updated as and when basis.

    what would you suggest for a search function... a text box sounds good... would the user be able to put in specific dates for payments... from this date to this date... and be able to get data in regards to that specific date frequency?

    Basically... any data that comes within those specific dates in question (01.01.05 - 01.04.05) should be highlighted in some colour, or put into a new sheet... anything that can identify data easily...

    I really appreciate your help with this... i have never gone this advanced into Excel and am happy that i think you know what i am looking to achieve.

    Let me know if you need further details to answer my Q.

    Many thanks,

Posting Permissions

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