Blank rows

[shone]

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 fro
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
+-------------------------------------------------------------------

 

[robert111]

why not run a simple macro to delete all blank rows AFTER edit, copy
paste special values onto a spare shee

 

[shone]

How to create and apply one?

And, can problem be solved via some simple formula?
(I suck at macros )

btw,
thanks for reply