extract data

[george]

I have a spreadsheet that contains a bunch of financial data.
Say I have 10 columns

In column H if it does not contain BLANK I want to copy
that row into a new worksheet?

how do I do that? Basically extracting all the rows that have
a value in column H.

Thanks,
George

 

[DDM]

George, use an advanced filter (Data > Filter > Advanced Filter) to do this.
For instructions on setting up the filter, look here:
http://www.contextures.com/xladvfilter01.html, Item 1c. (Extract to another
worksheet).

For instructions on setting up the criteria, look here:
http://www.contextures.com/xladvfilter02.html.

For your criteria, try =NOT(ISBLANK(H2)), adjusting the cell reference as
necessary.