Updated filtered data on next sheet

F

FARAZ QURESHI

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA 4
Copying filtered data 0
update sheet with data at bottom of present data 1
Particulars data Filter from sheet 1 to sheet 2 automatically 4
Data Lookup using find and filtered dropdowns 1
Extract data from list for Summary worksheet. 0
"Unspecified Error" when loading an XML spread sheet with XML Maps 1
Outlook 2k3 - WAB corrupted after microsoft XP program Updates dated 4-14-2006 - anyone else?? 1

Top