Hi!
I have different worksheets which are link together to automatically update values. These worksheets are in a folder as shown in my code. Now I want to reuse the worksheets, so I copied the worksheets and put them in another folder named "2019-2020". I then proceeded deleting the values of the worksheets except the formulas. I found out that the formulas does not dynamically changed the reference. What should I do so that whenever I want to reuse my worksheets, I will no longer change my formula, it will just dynamically change. Is this possible in excel?
=SUM('H:\School Matters\TLE Department Files\2018-2019\Year-End Requirements\Students'' Academic Profile\[1st Grading Students Academic Profile 2018-2019.xlsx]By Level'!B$76:B$77)
Bookmarks