No. 4: Link

XLCubed – Blog

Link:
feature in Excel explained by

Nurol Arslan, CEO & Partner
bsgroup-data-analytics-xlcubed-blog-define-member-set

Our fourth XLCubed feature

The formula has two main functions. Firstly it jumps to another location in the workbook, like a hyperlink, and secondly it passes parameters held in one cell into another cell. When you follow the hyperlink, XLCubed jumps to the sheet stored at LinkLocation and sets the parameters at the specified parameter addresses. You will find the video on youtube or even better, join us directly on LinkedIn in our expert group.