+ Reply to Thread
Results 1 to 2 of 2

how to return original equation after macro has ran

Hybrid View

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    how to return original equation after macro has ran

    hello everyone i have a macro created where it will adjust the income and expenses a user inputs into my excel spreadsheet based on the number of months. It is utilized by a userform called "annualize" where the user will select which financial statement they would like to adjust the income and expenses. for example, if we don't have a full 12 month operating statement, i will adjust the income and expenses to the date of the current statement. so how the formula works by:

    (sumifs formula)*month of financial statement / 12

    pretty much my question, how can i return my calculations back to the original sumifs formula instead of "(sumifs formula)*month/12




    return original equation.xlsb

  2. #2
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: how to return original equation after macro has ran

    nevermind figured it out. sorry for wasting your time.

+ 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. Return to original page & cell after macro
    By aljanga in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 10:09 AM
  2. Macro to delete set of cells but return to original cell
    By hani9041 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-29-2012, 03:48 PM
  3. Return to original worksheet
    By Mickmac in forum Excel General
    Replies: 2
    Last Post: 05-24-2011, 08:41 AM
  4. [SOLVED] Return to Original Workbook
    By ajvasel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-09-2006, 10:39 PM
  5. [SOLVED] Relative return to original worksheet in middle of macro
    By alexmillner@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2006, 02:00 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