Worksheet find

On Jul 27, 12:15 pm, shunulu <shun....RemoveThis@gmail.com> wrote:
> On Jul 26, 11:58 pm, dzelnio <dzel....RemoveThis@yahoo.com> wrote:
>
> > 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

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

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



On 7/26/07 4:58 PM, in article
1185483528.682506.236800 RemoveThis @o61g2000hsh.googlegroups.com, "dzelnio"
<dzelnio RemoveThis @yahoo.com> wrote:

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

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



On 7/27/07 5:15 AM, in article
1185527719.178400.19970 DeleteThis @57g2000hsv.googlegroups.com, "shunulu"
<shunulu DeleteThis @gmail.com> wrote:

> On Jul 26, 11:58 pm, dzelnio <dzel... DeleteThis @yahoo.com> wrote:
>> 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
>

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

On 7/31/07 4:12 AM, in article
1185869530.540545.112690.TakeThisOut@b79g2000hse.googlegroups.com,
"peterthebag@yahoo.com" <peterthebag.TakeThisOut@yahoo.com> wrote:

> 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.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

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.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Thanks tons everyone. I have plenty to go by.

Dzelnio

On Jul 31, 4:50 pm, peterthe....RemoveThis@yahoo.com wrote:
> 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.
>
> > --
> > Bob Greenblatt [MVP], Macintosh
> > bobgreenblattATmsnDOTcom