Linking another sheet within a formula

Vanessa Munoz

If I link another sheet's cell within a formula and I copy that formula horizontally, will the linked cell in the other sheet move accordingly?

Paul Newcome

No. When you create a cross sheet reference, the cells referenced in that range are static. There are options though for referencing multiple columns within the same range and dynamically determining which column from that range it should pull from. If you are able to provide more details, we may be able to help you set something up.