May 08 2019 08:18 PM - edited May 08 2019 08:45 PM
I have a workbook with a list of locations. I parse out shared workbooks to respective regional managers. The regional managers enter contractor information and hours worked at each location.
I want to reference their hours for each day into my master sheet.
The problem arises when the regional managers sort their lists by some metric - say zip code. The data source location changes and my reference formula only targets the cell.
Is there a way for my reference formula to "follow" the data?
='[Regional Store Locations.xlsx]Sheet1'!A1 is the reference formula im trying to manipulate
May 08 2019 10:16 PM
May 08 2019 10:28 PM
Thanks, @Jan Karel Pieterse . How do I Get Data from a cell as opposed to a sheet?
May 09 2019 08:53 AM