Normally I tear the books and online help apart looking for the answer before I turn to the forum... This time I thought I'd reverse that, as I'm thinking there might be an obvious answer already out there:
I want to sort (and simultaneously combine into a single column) all the (filled) cells found in several rows (of varying lengths). In other words, it looks like a checkerboard and I want to throw all the data into a single column.
I'd start by selecting special cells (formulas) - but is there a simple way to then dump all the contents a single column? - or is it just a matter of "crafting this together" in VBA?