INDIRECTs That Don't Break When You Change Worksheet Names
If you've ever worked with INDIRECT() functions, you've had the problem of them breaking when someone changes the worksheet names. This is a workaround to this problem; best of all, it doesn't use Visual Basic.
This is especially useful when trying to consolidate cash flows into a portfolio or any "rollup" of information from multiple worksheets.
Want to learn more? Check out my Excel modeling class at:
https://www.kahrrealestate.com/produc...