Here's my situation:
Sheet1 contains my source data, sorted alphabetically by Name.
I want Sheet2 to use cell references from Sheet1, not the values.
Then I want to be able to sort Sheet2 by a different column.
None of these have worked:
* inserting a new sheet, then copying the data.
* inserting a new sheet, then look in Paste Special, but I don't see an option for cell references.
* Copying Sheet1.
Questions:
+ What commands do I need to use to make this happen?
+ Am I right that I need absolute references, not relative?
Thanks,
Nancy
Bookmarks