Can't figure out a formula

[brian]

I don't know where to start on this formula-

For example: In E6 on sheet 2 I want to insert data from
sheet 1 as long as cell G7 on sheet 1 dose not contain the
word CLOSED. Additionally, In the same formula I would like
for the entire row on sheet 2 to be deleted once the word
closed is typed in G7. I'm going to be doing this for 3
different cells per row on sheet 2.

Thanks
Brian

 

[ksnapp]

Try this

if('sheet 1!g7<>"Closed", "data to insert","") in E6

As for the deleting of rows, that is a VBA sub. There is a perfect
discrition for one in the VBA section of the website that deletes rows
based on date criteria.

 

[JE McGimpsey]

Worksheet functions can only return values, they can't delete rows.


E6: =IF(Sheet1!G7<>"Closed", Sheet1!A7,"")

will display the value in Sheet1, cell a7 as long as G7 in sheet1 is not
"Closed".

To delete rows, you'd need to use event macros. Post back with more
details about your data layout if you want to try that. But in that
case, you may not need the conditional if the row containing the formula
will be deleted.