Thank you swisse,

I should have mentioned that I was using

=IF(master!$P2=0,"",+master!H2)

which, like your suggestion gets the job done but I have to resort
sheet2 to get the blanks out.

I'd prefer a solution that would add a row of data in sheet2 when the
criteria was met in the master sheet, without having to copy and paste
formulas and sorting data.

Thanks again,

Steve

swisse wrote:
Let's say you have 2 sheets in your workbook. In sheet2 put this
formula in
cell A1:
=IF(ISBLANK(Sheet1!A1);"";Sheet1!A1)
In sheet1cell A1 put some number or text, press Enter, go back to
sheet2 and
check if it copied what you wrote in A1.

Swisse