Hi to all Experts!

// problem:

I have two sheets:

- sheet#LIST (col1-ID, col2-QUANTITY, col3-PRICE)
- sheet#STOCK (col1-ID, col2-QUANTITY, col3-PRICE)

In a sheet #STOCK I manually type all data.
What I want from sheet#LIST is to display all data in a rows from
sheet#STOCK only if second column (QUANT.) is not empty.

I managed to do this with a formula:
=IF(STOCK!$B2<0,STOCK!$A2,\"\")

but,

I don't want Excel to display blank rows as a result.
I want to fill first next row with available data.

I attached file with this post to make a picture more clear.

CHEERS :)


+-------------------------------------------------------------------+
|Filename: SKIP_BLANK_ROWS.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5254 |
+-------------------------------------------------------------------+

--
shone
------------------------------------------------------------------------
shone's Profile: http://www.excelforum.com/member.php...o&userid=35126
View this thread: http://www.excelforum.com/showthread...hreadid=574138