B
Bookish
I have a worksheet (Sheet 4) with approx 175 rows of data. Each of these
rows links (by specific cells) to another sheet in the same workbook. For
example: Row 1 links to Sheet "Row1", Row 2 to Sheet "Row2", etc.
I need to be able to sort the data in Sheet 4 without changing the data in
the linked worksheets (I'd be sorting Sheet 4 by name or by revenue or by the
data in lots of other columns....it'd depend on the information required for
a report). For what it is worth--I'm using the other sheets as the method of
inputing data into Sheet 4.
I'm using Excel 2003.
rows links (by specific cells) to another sheet in the same workbook. For
example: Row 1 links to Sheet "Row1", Row 2 to Sheet "Row2", etc.
I need to be able to sort the data in Sheet 4 without changing the data in
the linked worksheets (I'd be sorting Sheet 4 by name or by revenue or by the
data in lots of other columns....it'd depend on the information required for
a report). For what it is worth--I'm using the other sheets as the method of
inputing data into Sheet 4.
I'm using Excel 2003.