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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidating Values 5
Incrementing rows and columns 1
Excel VBA help: Text file formatting 19
Append One Array to Another, and Consolidate 47
How to Combine Columns of Text - sounds easy 9
Arrays and scattered cell values or another way? 16
Progress Bar 1
Variable arrays & checkboxes 3

Back
Top