Nov 10 2022 09:47 AM
I pull metrics for over 100 different names from two different workbooks, I use VLOOKUP to pull these from the multiple sheets in the workbooks. The sheet names never change but the file names will change. I have to pull these 4 times a month so it is 8 different files.
=VLOOKUP($A8,'https://comm.sharepoint.com/Documents/Metrics/LaGrange/November/[ITG_East (53).xlsx]MeterSummary'!$B$7:$T$63,4,FALSE)
The above is one of the formulas i use, the only thing that changes on the formula is the Blue text everything else stays the same, is there a way to quickly go in an change this other than manually going into the formula to change it every time before i auto fill.
Nov 10 2022 09:56 AM
Nov 10 2022 10:03 AM