 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2005Sorting
1st Thanks for reading/helping, I sure can't get this to work. I have a group of numbers on sheet 1, these numbers are then sent over to sheet #2 and sorted. I want these numbers to be resorted when I go from sheet 1 to sheet 2 automatically As of now when I change sheets I have to manually resort the numbers with the sort command. Thanks Bobby How do you "send" the numbers to Sheet2? If you had a simple linking formula on Sheet2 that "pulled" the numbers from Sheet1 (i.e. =Sheet1!A1), then you could try this in a "helper" column, where this formula would *display* the numbers of the "pulling" column in ascending order: =SMALL($A$1:$A$10,ROW(A1)) And copy down.  SignatureHTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== 1st Thanks for reading/helping, I sure can't get this to work. I have a group of numbers on sheet 1, these numbers are then sent over to sheet #2 and sorted. I want these numbers to be resorted when I go from sheet 1 to sheet 2 automatically As of now when I change sheets I have to manually resort the numbers with the sort command. Thanks Bobby |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.