Combine Data Ranges

[Al Delgado]

I have 22 identical data ranges, 5 columns wide, that I want to combine into one range. The ranges are all on the same sheet. I could place the ranges on separate sheets if that make things easier. The data in the ranges is generated by array formulas, so at the end of the range are blank rows, I do not want to include the blank rows in the combined range.
Thanks

 

[Somendra Misra]

Hi,

This is cross-posted here at
http://www.excelforum.com/excel-general/1050451-combine-data-ranges.html

You must specify the link for the cross posting.

Can you upload a sample file.

Regards,

 

[Al Delgado]

The calculation tab has 4 ranges that I would like to combine into one long range 5 columns wide.
Thanks

 

[Al Delgado]

Here some other sites I have posted question to.
http://www.excelforum.com/excel-gen...tek-tips.com/viewthread.cfm?qid=1740805[/url}