help with a function to be located in Feb!I15 that does simple subtraction of previous sheet, Jan!R15 - Jan!T15, results displayed in Feb!J15
Thanks in advance
help with a function to be located in Feb!I15 that does simple subtraction of previous sheet, Jan!R15 - Jan!T15, results displayed in Feb!J15
Thanks in advance
In I15 on the February sheet:
=Jan!R15-Jan!T15
Or do you mean something more dynamic???
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thanks, looking for it to display the result in Feb!J15
Then put the formula into that cell, or put the formula in I15 and in J15 put this:
=I15
thanks, that works
Gosh, it really was that simple? Well, really glad to have helped.
I have unmarked this as solved is it fair to ask a followup ?, How would you make this more dynamic? as I do have 12 sheets and they ref. the previous sheet, except for sheet 1 of course
not a way for excel to have a formula in a cell and send the result to another cell?
Last edited by dad812; 08-08-2018 at 09:21 AM. Reason: more information
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks