Forum Discussion
Automatic update of worksheet name in formula
I have several worksheets within the same workbook in which data is pulled from a worksheet titled "2017 Budget". I would like to update this workbook with my 2018 budget numbers. Is there a way t...
Amy,
Do rename the worksheet "Budget 2017" to "Budget 2018", and the formulas in other worksheets that connected to this worksheet will change automatically!
Give it a try!