Function from sheet to sheet

  • Thread starter Thread starter doudou
  • Start date Start date
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 :)
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want to track time while paste value in multiple column of same roe 1
Count the columns from one sheet and paste it in another sheet 0
Excel, assign cells in multiple worksheets from one sheet 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Dependent drop down dynamic range formula, off sheet. 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Vlookup and return sheet name also 2
Match and delete rows on two different sheets from reference numbers 4

Back
Top