Function from sheet to sheet
 

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 :)


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=382205

what do you mean by special codes


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382205

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.


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=382205

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

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


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382205

nope, doesn't work.
What is it supposed to do, actually ?


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=382205

Can you provide some sample data along with expected results?

doudou Wrote:
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 :)


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=382205