Function from sheet to sheet

D

doudou

Hi,

I wander if it is possible to assign for task a sheet to reproduce all
the lines written in another one that has a special code written as
value of a column' cell ?

thanks for your answers :)
 
D

doudou

I mean for example that sheet B must reproduce what in sheet A has for
value "cash" in column X.
And I mean line by line, not as a sum.
 
A

anilsolipuram

copy this formula in sheet2 at x1 cell and drag it down till the las
cell you want to copy.

=IF(ISERROR(FIND("cash",Sheet1!X1,1)),"",Sheet1!X1
 
Top