How to change just one value in each cell and apply the changes:
='C:\Users\joshl\OneDrive\Documents\[NOVEMBER 2019 VERSAILLES.xlsx]Sheet1'!$E$138
='C:\Users\joshl\OneDrive\Documents\[december 2019 VERSAILLES.xlsx]Sheet1'!$E$138
='C:\Users\joshl\OneDrive\Documents\[january 2020 VERSAILLES.xlsx]Sheet1'!$E$138
How do i change the formula in each cell to change only the last part. For example if I want to change the last part "Sheet1'!$E$138" to "Sheet1'$E$145".
Bookmarks