Hello,

I have an existing spreadsheet that contains account information such as
account number, name, rating loan balance, net balance, etc... This
information is contained in a worksheet named Data. I need to create another
report from some of the info on the Data tab. I have created a new tab named
"Watch". I need to get all account numbers, name, rating, and balances where
the rating of the account = 5. I need help with a formula that will enable me
to get the information I need contained on the Data tab onto the Watch tab.
Also, when this report gets updated I would like the info on the Watch tab to
also get updated. Any help with this will be greatly appreciated. If you need
more details just reply to this post and I will be sure to provide what is
needed. Thank You.
Dave Y