+ Reply to Thread
Results 1 to 2 of 2

How can I change values in multiple cells with one click

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    Essex
    MS-Off Ver
    MS 2016
    Posts
    21

    How can I change values in multiple cells with one click

    Okay, apologies for the odd thread title but I don't know how else to explain my issue.

    I have a financial model that drives P&L, BS and CFlow for the business. It is made up of multiple data tabs, one of which is a salary tab. The salary tab has all employees salary costs and benefits for the year broken down by month. Therefore, if I change any of these values or remove/add an employee it will immediately update all values in the model.

    I now want to create a scenario whereby from August to December certain employees will be removed from the business, thus removing all associated costs and showing an improvement to cash flow. BUT, I easily want to switch between this scenario and the current scenario whereby these employees remain within the business.

    Having reviewed scenario options within Excel I can't see how to set this up for this specific problem. I also recorded macros of the values being removed, then reinstated, but when I hit the command buttons it totally messed up the model so perhaps that isn't an option.

    Could anyone please advise on the best way forward? It seems relatively simple to me, I literally want two command buttons on the executive summary. One stating 'Pre-Restructure' one stating 'Post-Restructure' and literally switch between the two scenarios at will.

    Hope the above makes sense, can't really attached an example as such.

    Thanks
    Simon

  2. #2
    Registered User
    Join Date
    12-17-2016
    Location
    South Wales
    MS-Off Ver
    Excel 2007, 2016
    Posts
    68

    Re: How can I change values in multiple cells with one click

    Two thoughts:

    1) put a marker by records to be deleted in the alternative scenario, and filter to hide the marked rows. Make sure that formulae referencing that tab are SUBTOTAL rather than SUM, so they can be set to ignore hidden rows.

    2) have separate salary tabs, one per scenario. Make any formulae that reference the salary tab INDIRECT formulae - this will allow you to have a single cell on the spreadsheet containing the sheet name of the salary tab you want to use.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simultaneously change values in multiple cells?
    By Jon C in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  2. [SOLVED] Simultaneously change values in multiple cells?
    By Jaclyn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-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