I apoligize if this is in the wrong spot, not sure where to start (or even what to search for here), so I'll just explain what I want to do:
I have a single Excel Workbook that has 3 sheets.
Sheet 1: Output
Sheet 2: Current MTD
Sheet 3: Budgets
On the "Output" sheet I pull data currently from the "Current MTD" sheet through various formulas to output the data and metrics I need. What I'd like to be able to do is have a button that I can push that would change all of the formulas so that the main sheet now pulls from the "Budgets" sheet and applys different formulas.
Basically I'd like to change some of the data and formulas at the "Output" sheet at the click of a button, and then change them back either with the same or different button, whichever is easier. I have no experience with VBA scripting or macro's (if that is what this requires), but am a geek and so have a passing understanding of programming and am willing to learn.
As always, thanks a ton in advance for any help or direction!!
Bookmarks