create a consolidated text list from multiple ranges
1 Attachment(s)
Hello all and thanks in advance.
What I am trying to accomplish is to have a consolidated list that excludes blank cells in another range. For instance: Ranges A5:A11, A13:A19, A21:A27, and A29:A32 on 'project' tab would all contain text or blanks. What I would like to happen is have all of the 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 have included an example file to better illustrate what I need. Any help would be greatly appreciated |
All times are GMT +1. The time now is 10:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com