Excel: with an if condition display a row of cell if true

Hello,
I am a relatively new user and I was asked to set up a contact list for my
office. I would like to have one master list on the first worksheet and then
kind of query different sections into new worksheets. Is this possible?

For example in the main worksheet i would have name, region and supervisor.
In the second worksheet I would want only Peel Region enteries to be
displayed.

The main goal is: If a change something on the first worksheet I would like
the other worksheets altered automatically.

PLEASE HELP ME.

Copy the data that you want from the main worksheet and then paste it into the other worksheet but don't just paste it, select "Paste Special" then select "paste as link" hit OK.

HTH
JG

Thanks but I want to Query the worksheet. For ex If I add a new listing to
the master worksheet I want it to automatically add itself to the second
worksheet. Can this be done?

"pinmaster" wrote:

>
> Copy the data that you want from the main worksheet and then paste it
> into the other worksheet but don't just paste it, select "Paste
> Special" then select "paste as link" hit OK.
>
> HTH
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=495632
>
>

Yes, one way is to do what I told you, but instead of selecting a few rows select the entire column then paste into the other worksheet as "link" Paste Special/Paste Link. Another way is to type the formula directly into the other worksheet, somethink like:

=IF(SHEET1!B1="","",SHEET1!B1)

then copy down as needed.

HTH
JG

ok the formula would be for the enite column in the worksheet 2, right?
so,
=IF(SHEET1!B1="Peel","",SHEET1!B1)
what else do i do? in the second quotations what should i put?
so that in worksheet 1, the column labelled Region, if there are peel
entries the entire line of data will show in worksheet 2


SORRY AND THANK YOU!!!!!!!!



"pinmaster" wrote:

>
> Yes, one way is to do what I told you, but instead of selecting a few
> rows select the entire column then paste into the other worksheet as
> "link" Paste Special/Paste Link. Another way is to type the formula
> directly into the other worksheet, somethink like:
>
>
>
> then copy down as needed.
>
> HTH
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=495632
>
>

Actually your formula should look like this:
=IF(Sheet1!B1="Peel",Sheet1!B1,"")

here are the basics:
=IF(condition, if true, if false)

but I would go with this:

=IF(Sheet!B1="","",Sheet1!B1)

open a blank worksheet inside your workbook then select any column and while the column is still selected type my formula in the formula bar then hold down the CTRL key and hit Enter, that will copy the formula in the entire column. Then come back and let us know if that is what your looking for.

Note. the quotations are use to leave a cell blank or to check if a cell is blank.

Regards
JG