I need help making a table. I want to make a table in a worksheet (sheet 2)
that incorporates numbers that are calculated in another worksheet (worksheet
1) in the same workbook.
The 1st column of the table contains a list of numbers (loan amounts). The
2nd and 3rd columns are to contain numbers (calculation 1 & calculation 2)
that correspond to the numbers in the 1st column. Worksheet 1 is a modified
loan amortization calculator. Calculation 1 & calculation 2 are specific to
the loan amount entered. In the table, the 1st cell of the 1st column will be
10,000 and increase by 5,000 increments. When I enter a loan amount in the
calculator (worksheet 1), I want calculation 1 & 2 to be placed in the 2nd &
3rd columns of the table and in the row that corresponds to to the loan
amount entered in the calculator.
For example: in the table, the 1st row will have 10,000 in the 1st column.
When 10,000 is entered in the calculator, calculation 1 & calculation 2 would
be entered in columns 2 & 3 of the same row. The 2nd row of the table will
have 15,000 in the 1st column. When 15,000 is entered in the calculator,
calculation 1 & calculation 2 for that amount would be entered in column 2 &
3 of that row, and so on down the table.
I will be making 8 separate tables. Each table will have the same loan
amounts in column 1. Calculation 1 & 2 will be different because a different
interest rate will be used.
Thank you for your help.

--
dow