I just had to do something similar at work. I linked my main worksheet
to a second worksheet by placing an "X" (or, in your case, "peel") in a
column (in my case below, column N) for the entries which I wanted to link to
the second worksheet.

Here is a sample of the code I used (just apply it to each cell or group of
cells in your second sheet for the data that you want linked to your second
sheet):

=IF('Active Matters'!$N3="X",'Active Matters'!A3,"---")

Unfortunately, you can't get rid of the blank rows because they are
directly linked to the same rows in your original sheet (or, if someone knows
how to reconcile this, please feel free to respond). For my sheet, I didn't
want to collapse the rows incase I do put an "X" for those rows on my main
sheet to appear on the second sheet in the future, but that might work for
your purposes if your sheet isn't constantly fluctuating and growing, like
mine is. To make my second sheet look cleaner instead of displaying blank
rows, I entered subsquent code so that "---" displays (instead of the code
itself or a blank line, which would look busy or confusing). Probably a good
idea to lock your cells and password protect the code on the sheet that you
are linking to.

Once your sheets are working, be careful not to delete any rows or
columns in either sheet, and do not insert rows or columns using the insert
feature (instead, type all new entries at the very bottom and then sort - use
the same practice for deleting data), or else the cells become linked to the
wrong cells on your second sheet.

Hope this helps.

Katy



"Seema Yadav" wrote:

ok so thats now showing me just peel. I need the entire row of info along
with the "check" cell (ie Peel). also there are spaces between the rows
(where it doesn't meet the criteria) can i shift them up so that they're are
no blanks?

"pinmaster" wrote:


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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495632