create a consolidated text list from multiple ranges

E

elcarp

Hello all and thanks in advance.

What I am trying to accomplish is to have a consolidated list tha
excludes blank cells in another range. For instance:

Ranges A5:A11, A13:A19, A21:A27, and A29:A32 on 'project' tab would al
contain text or blanks. What I would like to happen is have all of th
non blank cells populated (condensed neatly) in a list in another range
say B4:B29 on 'quote' tab.

I'm certain this can be done, but I can't figure it out. I hav
included an example file to better illustrate what I need.

Any help would be greatly appreciate

+-------------------------------------------------------------------
|Filename: example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=687
+-------------------------------------------------------------------
 

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

Count Column B if Column A is within a multiple specificed ranges 2
a data validation list that contains a list of named ranges - not alist from a named range 1
Marco Help 2
Macro to tidy data 4
Problem creating a logarithmic trend line 2
data validation list from multiple non-contiguous named ranges? 3
Creating a Variable Range 2
MACRO Question - Help Please!!!!!!!!!!!!!!!!! 2

Top