Posted by JM on January 03, 2002 4:23 PM
I'm a low-level user so I may be missing something obvious.
Here's the deal - I have an enormous spreadsheet that needs to be sorted, by rows, in two different ways on different sheets in the same workbook. (ie - Each row will have the same info but on each sheet the rows will be in a different order) I want the second sheet to accurately reflect changes made on the original sheet so I don't have to input the data twice.
The closest I've found during my RTFM sessions & searching your archive is Linked Objects but I must not be doing it right if that's the answer. Also, the affected area is something like 40 columns by 500 rows so it's not something I want to type in each cell. Any ideas or (hopefully) easy fixes?