Worksheet find

[dzelnio]

Can I make worksheet2 import all rows from worksheet1 that include the
text
"- Brice" ?

How?

dzelnio

 

[shunulu]

Can I make worksheet2 import all rows from worksheet1 that include the
text
"- Brice" ?

How?

dzelnio

Yess, you can...

Press "Alt" and select sheet1 with a mouse, drag and drop it to next
side. Same sheet will be copied with a name "sheet1 (2)" you can
rename it. Btw you can group sheets with a "Apple" button. Then for
example, enter the data to sheet1, it will appear exactly the same
data on the same place in the sheet2

 

[shunulu]

Yess, you can...

Press "Alt" and select sheet1 with a mouse, drag and drop it to next
side. Same sheet will be copied with a name "sheet1 (2)" you can
rename it. Btw you can group sheets with a "Apple" button. Then for
example, enter the data to sheet1, it will appear exactly the same
data on the same place in the sheet2

U can use same way for worksheets. Open two worksheets together.
Choose Windows/Arrange/Tiled. Now just simply drag and drop sheets.
Rename it again

 

[CyberTaz]

Most likely this can be done using the AutoFilter or the Advanced Filter.
Check them out in XL Help if you're not familiar with their use.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

Although this accomplishes a certain goal it isn't what the OP is asking
He wants to have specific content copied - selectively - from one sheet to
another, not move or copy an entire sheet.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[peterthebag]

dzeinio
having got your data in sheet1 (lets assume data is in cell A1) go to
sheet 2 and enter this is cell A1 on sheet 2.

=(IF(Sheet1!A2="bryce",Sheet1!A2, ))

then copy this forumal to the rest of the row. This imports Bryce
into the cells and leves zero where bryce is not present.

Peter

 

[Bob Greenblatt]

dzeinio
having got your data in sheet1 (lets assume data is in cell A1) go to
sheet 2 and enter this is cell A1 on sheet 2.

=(IF(Sheet1!A2="bryce",Sheet1!A2, ))

then copy this forumal to the rest of the row. This imports Bryce
into the cells and leves zero where bryce is not present.

Peter

Peter, I think you got the formula wrong. First, you don't need the extra
set of parentheses. Second, your explanation states that the data is in
Cell A1, not A2 as your formula shows. The correct formula should be:
=IF(sheet1!A1="bryce","bryce",""). And, it is never good practice to leave
either the TRUE or FALSE term un specified. Excel will not always do what
you expect; often the word "FALSE" or TRUE" may be substituted for an
indeterminate expression.

 

[peterthebag]

sorry, yes I put my data in A2, but you can replace A2 with whatever
row/column has the source data in.

cheers,

P

 

[dave]

Thanks tons everyone. I have plenty to go by.

Dzelnio

sorry, yes I put my data in A2, but you can replace A2 with whatever
row/column has the source data in.

cheers,

P

Peter, I think you got the formula wrong. First, you don't need the extra
set of parentheses. Second, your explanation states that the data is in
Cell A1, not A2 as your formula shows. The correct formula should be:
=IF(sheet1!A1="bryce","bryce",""). And, it is never good practice to leave
either the TRUE or FALSE term un specified. Excel will not always do what
you expect; often the word "FALSE" or TRUE" may be substituted for an
indeterminate expression.