ExcelBanter - data sorting problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - data sorting problem (https://www.excelbanter.com/excel-worksheet-functions/13921-data-sorting-problem.html)

Pong

data sorting problem

I have a pool of data, eg. from C1 to S100, and there is some empty in
between column and rows. I have to transfer these data into another
worksheet which only have 50 rows available. How can I do it?

All times are GMT +1. The time now is 02:49 PM.