#### san111

##### New Member
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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.

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?

San111

Replies
4
Views
279
Replies
9
Views
197
Replies
1
Views
233
Replies
0
Views
268
Replies
11
Views
801

1,207,278
Messages
6,077,501
Members
446,286
Latest member
ropebender

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back