Oh I'm sorry, I definitely wasn't very clear.

This workbook is displaying information for a bank account. It contains
two worksheets. One is for data and updates. I have it set up so that
the accountant can go in at the end of each day and make any updates
with any transactions that occured during the day. In column K, I have
an IF function that displays the word "OUTSTANDING" if the transaction
in the row has not been offset.

The other worksheet is what the accountant can look at and have a nice
list of outstanding transactions. It is identical in positioning and
formatting to the data page. It uses VLOOKUPS to pull the information
from the data page, but only IF the cell in column K of the data sheet
has the word "OUTSTANDING" in it. If the way I just described that
makes sense, you can probably imagine that any outstanding transactions
show up while all others do not. For this reason, I have a bunch of
mostly blank rows that I would like to hide. I say "mostly" because in
column A, each row has a number (from 1 to 600) that the vlookups
reference. I do not want these numbers to change because the page
automatically updates based on activity in the data sheet.

I think that is about the best I can describe it in words. This
problem seems like something I would normally use an IF funtion for:
=IF(ISBLANK($K458),HIDE THIS ROW,DO NOTHING)

-or-

=IF($K458="OUTSTANDING",DO NOTHING,HIDE THIS ROW)

Thanks for all your help. Please let me know if you need any more
clarification.

Pat