+ Reply to Thread
Results 1 to 3 of 3

Button to change cell contents/formulas

  1. #1
    Registered User
    Join Date
    07-03-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    10

    Button to change cell contents/formulas

    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!!

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Button to change cell contents/formulas

    We would need to see both sets of formulae to help you with this.

  3. #3
    Registered User
    Join Date
    07-03-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Button to change cell contents/formulas

    Thank you so much for the quick reply! I've attached something similar to what I'm needing. I'm not looking for a perfect solution here all wrapped up, but more of an example so that I can extrapolate from there. As I said, I'm no guru but I can follow directions and expand on something once I know where to start.

    Flowers for ExcelHelp.xlsx

    Once again, thanks for any help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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