Results 1 to 2 of 2

Dynamic referencing pivot table and VBA programming

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    netherlands
    MS-Off Ver
    Excel 2011
    Posts
    2

    Dynamic referencing pivot table and VBA programming

    i love this site. been a lurker for some time but now i need help with a specific problem that i cant piece together the puzzle of.

    i have a raw data sheet that contains a monthly expenses pivot table with months in rows and spending categories in columns.

    what im trying to do is to have another sheet that contains two data tables, one for the current month and one for the next month. here i need the rows to contain the spending categories and have the columns available to do some formulas for budgetting purposes (which is why i dont want to use another pivot table).

    what i would like to have programmed is a button that, upon clicking, will load the next months data into the current months data and have the next month loaded with the third months data and so on. (and one that allows for going back one month) so i cant easily scroll through the months

    hopefully my question is clear! and thanks a lot.

    demo.xlsm
    Last edited by browntofu; 10-08-2013 at 06:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-09-2013, 06:58 AM
  2. Referencing
    By blinks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 08:56 PM
  3. Help with 3-D referencing - I think
    By *kev* in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2008, 10:24 PM
  4. Lookup referencing cell referencing range
    By cmcconnehey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2008, 06:19 PM
  5. 3-D referencing
    By YBeaupre in forum Excel General
    Replies: 0
    Last Post: 09-04-2005, 04:05 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