Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions |