My workbook has a portfolio of around 5000 entries regarding clients who have
been availing facilities like House Loans, Lease Finance and Business Loans
(Book 1)

Nature of such loans is classified in clomun Q as "HF", "LF" and "BL".

I want the Book 2 to be reflecting the records with respect to "Housing
Finance" entered in Book 1, being automatically updated with each new entry,
and similarly withBook 3 & Book 4 showing the other 2 classes of loans.

It would be easier to just apply an auto filter to the worksheet you have.
You can tell it to just show you all the "HF" clients you have at the current
time. You can even do a totals key using the SUBTOTAL formula. If you take
your existing data and go to Data - Create List, it will set up the auto
filters for you and make it easy to maintain your large dataset.

If you require separate worksheets, then this gets pretty complicated and
requires either array formulas or VBA (neither of which I can help with). I
would suggest you try the above approach first.

- KC Rippstein
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"FARAZ QURESHI" wrote:

My workbook has a portfolio of around 5000 entries regarding clients who have
been availing facilities like House Loans, Lease Finance and Business Loans
(Book 1)

Nature of such loans is classified in clomun Q as "HF", "LF" and "BL".

I want the Book 2 to be reflecting the records with respect to "Housing
Finance" entered in Book 1, being automatically updated with each new entry,
and similarly withBook 3 & Book 4 showing the other 2 classes of loans.