Hi!
Could someone please help me figure out a formula to take a value from one sheet and add to it in Excel 2010?
I'm naming the sheets but not necessarily numerically.
I have done it by manually entering the sheet name but would like it to figure out the sheet name automatically based on where the sheet is located in the workbook. That way I can copy the current sheet, rename it and still have it update properly with a running total.
Here is what I have now: =D7+'011514'!E7
Thank you for your time!
stubhelp.xlsx
Bookmarks