Auto Updating Filtered Data on Next Sheet
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. |
Auto Updating Filtered Data on Next Sheet
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. |
All times are GMT +1. The time now is 03:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com