Forum Discussion
CameronNEP
Dec 29, 2021Copper Contributor
External Wkbk links formula manipulation
Hi, 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 ex...
Riny_van_Eekelen
Dec 29, 2021Platinum Contributor
CameronNEP Remover the $ sign before 17. That makes the row number relative and update automatically when copied up or down.
- CameronNEPDec 31, 2021Copper ContributorBullseye, thanks!