I'm not sure if this is the right area to post this

Now I don’t think I need a macro for this. Just some advice on setting it up efficiently in a Pivot table. I have data of revenues for say 4 years which I will use to create 4 different tables. One table will show only data from 2006, another will show 2006 + 2007, another 2006 + 2007 + 2008, and the last one will show all 4 years revenues combined.
But here’s the tricky part, I don’t want to see all tables at once. I want to be able to select which table I want, and produce the table in the same ‘range’ on the spreadsheet.
Any ideas on how this could be achieved? I’m trying with pivot tables but its not working.


many thanks