| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I DISPLY DIFFERENT VALUES IN ARRAY'S TO ONE COLUMN?
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. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "mr pelser" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array's, Calculations and Results | Excel Programming | |||
| Help with array's | Excel Worksheet Functions | |||
| How do I return location (not value)of an Excel array's max value | Excel Programming | |||
| Selecting & Displaying An Array's Contents | Excel Programming | |||
| !!! Newbie VBA question about array's and listbox !!! | Excel Programming | |||
Linear Mode
