HOW DO I DISPLY DIFFERENT VALUES IN ARRAY'S TO ONE COLUMN?

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting values in an array where value in one column is not null	CW	Microsoft Excel Worksheet Functions	5	22nd Apr 2010 04:06 AM
Build an Array of Different Values From Column	Ryan H	Microsoft Excel Programming	2	26th Jan 2010 03:13 PM
Creating an column of values from an existing array	=?Utf-8?B?UEE=?=	Microsoft Excel New Users	1	20th Nov 2006 12:27 PM
How do I search an array for values in a column greater than zero	=?Utf-8?B?bGV0c2FnbWo=?=	Microsoft Excel Worksheet Functions	0	26th Jul 2006 02:41 AM
Looking up values from a 2D array instead of just a column	Gamesmith	Microsoft Excel Worksheet Functions	4	17th Nov 2003 03:58 AM