 |
 | 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 / Programming / December 2006HOW DO I DISPLY DIFFERENT VALUES IN ARRAY'S TO ONE COLUMN?
having trouble consolidating the different values from 10 columns on 10 sheets to one neat list on the 11th sheet without having to sort them after they are compiled. Is there an auto sorting way for consolidating? If you have keys then you can try the sumif function on the summary. otherwise it is probably a matter of creating the sheet with vba.  SignatureHope this helps Martin Fishlock Please do not forget to rate this reply. > having trouble consolidating the different values from 10 columns on 10 > sheets to one neat list on the 11th sheet without having to sort them after > they are compiled. Is there an auto sorting way for consolidating? |
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.