Creating hyperlinks to other worksheets in the same Excel workbook

Question

Hi all

I looking to render an excel workbook that functions the same as the attached Excel file.

Using the render tools to dynamically created sheets and then in a master sheet be able to link to those subsequent sheets.

Attached is a workflow I am trying to build to get this done but am only getting errors where the reference sheet cannot be found.

Any help would be appreciated.

Working Output.xlsx

IraWatt · Answer

Great to hear it worked @zheny0010 !

zheny0010 · Answer

That # sign is the key!!!

thanks a lot, I finally got it work

IraWatt · Answer

They key to finding the right format was to copy and paste the link into word:

Excel seemed to lie a bit about how the link was structured