External Wkbk links formula manipulation

New Contributor


I'm importing a series of values from one workbook to another and instead of creating individual External Workbook links, I'd like to be able to +1 the value of the initial row reference. For example with the reference formula below, in cell C44 I'd like reference this cell from another cell (F44) but have it automatically change reference from G17 to G18, and then repeat that a few more times (6 more for the days of the week):
='https://domain.sharepoint.com/sites/Sales/Shared Documents/[2022.xlsx]Jan 22'!$G$17


Any thoughts? Thanks!

2 Replies

@CameronNEP Remover the $ sign before 17. That makes the row number relative and update automatically when copied up or down.

Bullseye, thanks!