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
Bookmarks