Bernie,

I understood your ideia but the formula didn´t work.

Can u help me on this?

Thanks in advanced.

"Bernie Deitrick" escreveu:

Pedro,

On Sheet1, in cell B4, array enter (enter using Ctrl-Shift-Enter)

=IF(INDEX(Sheet2!B:B,SMALL(IF(Sheet2!$B$2:$B$1000< 0,ROW(Sheet2!$B$2:$B$1000),ROW(Sheet2!$B$1001)),R OW()-ROW($B$3)))<0,INDEX(Sheet2!A:A,SMALL(IF(Sheet2!$B $2:$B$1000<0,ROW(Sheet2!$B$2:$B$1000),ROW(Sheet2! $B$1001)),ROW()-ROW($B$3))),"")

and then copy that cell down until the formula returns blanks.

Assumes that you have less than 1000 rows of data....

HTH,
Bernie
MS Excel MVP


"Pedro Serra" wrote in message
...
How can I populate the values to a column in Excel sheet 1 with the values of
the column A in sheet 2 where the values of the column B in sheet 2, are
different that zero, without using a filter in sheet 2 and then copy past the
values?