 |
 | 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 / January 2006Sort data to other worksheets
Looking for a way to have a master worksheet that has approximately 10 colums by 400 rows. We constantly add rows to the sheet and then need to view it sorted in various ways. Is there a way to have the data from the master sheet displayed on other tabs in various sorts without copying the data to the other worksheets every time data is added. Maybe you can just apply Data|Filter|Autofilter and hide/show the data you want to see. > Looking for a way to have a master worksheet that has approximately 10 > colums by 400 rows. We constantly add rows to the sheet and then need to > view it sorted in various ways. Is there a way to have the data from the > master sheet displayed on other tabs in various sorts without copying the > data to the other worksheets every time data is added.  SignatureDave Peterson But this will not allow me to sort the data, just filter it. I need to see all date but in different sorts. Of course I can manually copy to the additional worksheets and manually sort but that sounds kind of silly. There has to be a better way. Thanks > Maybe you can just apply Data|Filter|Autofilter and hide/show the data you > want [quoted text clipped - 5 lines] >> master sheet displayed on other tabs in various sorts without copying the >> data to the other worksheets every time data is added. Sort your data the way you want, then filter to show what you want. I've found that it's always easier to keep the data in one location. You may like this technique to make the sorting easier: http://contextures.com/xlSort02.html from Debra Dalgleish's site. By the way, xl2003 has a sorting option under the autofilter dropdown. > But this will not allow me to sort the data, just filter it. I need to see > all date but in different sorts. Of course I can manually copy to the [quoted text clipped - 16 lines] > > > > Dave Peterson SignatureDave Peterson |
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.