Formula that moves with Worksheet additions
I have a form that I created but I need help with creating a formula that "moves" with every worksheet addition. For example all the totals in Lottery Log End (Row 13, Row 20 and Row 27) would be the Begin (Row 11, Row 18 and Row 25) total for the second worksheet. I don't want to correct the formula in each successive worksheet that I add. I will be adding a new worksheet for each day so 365 in total.
CLOSING LOG.xlsx
somewhere on the form
use this formula to get the sheet number/name
Formula:
Please Login or Register to view this content.
minus 1 from that and you will the sheet name of the previous sheet
i used W1 in this case
with that you can then set up indirect formulas to that sheet like
in b11Formula:Please Login or Register to view this content.
C11Formula:Please Login or Register to view this content.
file attached
i didnt do all of them
just enough to get you started
one thing about this file though
if you dont require the active connection to previous sheet any more
i suggest go back and overwrite the formula and hard code it
having that many volatile formulas over that many sheets can be make the sheet performance degrade over time
Last edited by humdingaling; 01-16-2014 at 01:38 AM. Reason: file attached
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
humdingaling,
I wanted to thank you for helping me out. Sorry it took me a while to respond but I really appreciate your help and wanted to thank you for introducing me to the INDIRECT formula!
not a problem
indirect is indeed a nifty formula
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks