Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting and copy-format
to maintain data consistency, i use formula "=" a reference cell's value. when
sorting by different criteria (headers), the link list in Excel cannot link cleverly but say, still pointing its above content, how to solve this problemin Excel? In Word, copy-format is simply shift-ctrl-c, why excel hasn't supported such a shortcut? just ask to know anybody can figure out a reason so this is not asking Microsoft per se Thanks a lot. |
#2
|
|||
|
|||
I don't think you'll find a fix to your sorting problem.
I choose a nice unique field and type that in the second worksheet. Then I can either use =vlookup() or =index(match()) to return associated values. And the sorts work better, too. You could look at Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html For more info. Ieyasu wrote: to maintain data consistency, i use formula "=" a reference cell's value. when sorting by different criteria (headers), the link list in Excel cannot link cleverly but say, still pointing its above content, how to solve this problemin Excel? In Word, copy-format is simply shift-ctrl-c, why excel hasn't supported such a shortcut? just ask to know anybody can figure out a reason so this is not asking Microsoft per se Thanks a lot. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting formatted numbers | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
Sorting Data and Formula help... | Excel Discussion (Misc queries) | |||
use data on master worksheet for sorting | New Users to Excel |