linking worksheets

[san111]

Each row on my worksheet is information on one (1) customer. However, I would like to see a payment history (table of dates paid and amounts received) of the customer. How could I set this up in Excel?
This message was edited by san111 on 2002-09-16 14:50

 

[DonkeyOte]

Perhaps I am missing the point - but you could use hyperlinks I think...click to go the sheet of the supplier - and you could do that by hyperlinking the name of the supplier or whatever on your sheet with the rows.

 

[san111]

I will give an example:
Worksheet1:

Customer# Last Name First Name etc.
--------------------------------------------
001 Smith Dan
002 Moore Roger
003 Daniels Jim

THe above is an example of my work sheet with customer information. Now I would like to be able to click on for example a "+" sign to open a new worksheet on one (1) customer which would show their payment history . This should look like this:

Date due Date Paid amount due Amount paid
--------------------------------------------
01/01/02 01/04/02 $20.00 $20.00
02/01/02 02/03/02 $20.00 $20.00
03/01/02 03/05/02 $20.00 $20.00


Is this possible in Excel?

Thank for your help
San111