View Single Post
 
Old 09-01-2011, 04:10 AM
waqer waqer is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 4
waqer is on a distinguished road
Default Linking sheets to fetch transactions from sheets to another

I have created two sheets. One sheet contain basic data about customers such as account number, loan amount etc and other sheet list transactions of all customers in chronological order. I have created third sheet to allow me see report of each customer in similar fashion like a bank statement. I am able link this sheet to the first sheet to display basic information by using VLOOKUP function. Now I select/type account number of desired customer and corresponding information is displayed.

However, I need guidance regarding linking this sheet to second sheet to fetch transactions of only desired customers. I have tried little bit through VLOOKUP function but it only displays first transaction.

Please me suggest some ways to accomplish desired task.
Reply With Quote