Download now Free registration required
A common task in report development is to generate EXCEL spreadsheets that have logical links between the various worksheets. Quite often, it's desirable to insert hyperlinks in selected cells to link a particular row to related data in other worksheets creating a type of drill-down report structure. The specific need in this instance involved the requirement to link various data elements pertaining to bank loan applications. But the methodology is pertinent in any situation involving the development of multiple spreadsheet-based reports that contain logical relationships. This paper outlines the use of the EXCEL function HYPERLINK in conjunction with SAS to produce linked spreadsheets.
- Format: PDF
- Size: 872.3 KB