Ignore blank Cells

[blackstar]

i have a workbook with about 30 sheets. in these sheets there are multiple rows(about 300) some with data some with no data. i want to create another sheet in this workbook that would display only information from cells in the other 30 pages that have data. so if out of 300 rows some of them have names. i want this new worksheet to show those names and be able to combine that information into all into this new worksheet...

[raypayette]

Sort the data and copy the relevant info.

[freekrill]

I have a similar issue with blank cells. Here is the set-up:

On Sheet1, I have a series of data in cells A101-A200, which can also include blank cells

On Sheet2, I have formulas in cells A1-A100, =if(B1="","",B1+C1), etc.

What I need to do is to copy from Sheet2, A1-A100, and paste the values to Sheet1, A1-A100.

I then need to sort in descending order the values which now exist in A1-A200.

My problem is that the blank cells which come from pasting the values from Sheet2 are sorted to the top of the column, while the blank cells which were originally in cells A101-A200 are sorted to the bottom, with the actual non-blank values somewhere in between.

All of this is done by a macro.

Anything I can do so that the values are all sorted normally, with the blanks coming at the end?

I can't change the formula to =if(B1="",0,B1+C1), because sometimes B1+C1 = 0 and sometimes B1+C1 is negative.

Any suggestions?, or ways I can make the problem clearer?

[raypayette]

Perhaps you should read:
http://www.mvps.org/dmcritchie/excel/delempty.htm
http://www.contextures.com/xlDataEntry02.html