Need to link the Excel sheet from other sheet inside same execl work b...

Pradeep3 · Posted 06-18-2020 02:17 AM

I have one summary sheet and there are rest 4 sheet. I have to link the summary sheet with other sheet for example

In Summary sheet i have one column(Theme) with 4 values if i click white it will go to sheet which is defined on that value and vice-versa.

Theme

White

Green

Bule

Grey

Please help me for the same.

Norman21 · Posted 06-18-2020 07:42 AM

Welcome to the SAS Community!

I'm not sure, but it sounds like you want to write within-workbook hyperlinks. If so, the following might help:

Norman.
SAS 9.4 (TS1M6) X64_10PRO WIN 10.0.17763 Workstation

Need to link the Excel sheet from other sheet inside same execl work book