Sorting & Filtering Linked Cells From Source Sheet
I am unable to figure out how to sort and filter linked cells from the source sheet.
I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard for this function due to the need for a specific layout, exporting and printing.
The source sheet has a text column of 'Unit Numbers', the other columns are primarily date columns and text columns. The links start on Row 30 below other links which do not need to filter or sort. Some of the other columns are/can be formulas.
Any assistance is appreciated.