I must be out of practice cause I'm stuck on this. Its all in the same workbook.
Worksheet #1
In A1 I have a payment schedule #
In B1 I want the payment amount associated with the payment schedule listed in A1.
etc, etc, theres over 300 rows with 11 different payment schedules.
Worskeet #2
In A1 I have the payment schedule #
in A2 I have the payment amount
etc, etc. Theres 11 different payment schedules.
How do I make it work automatically so if I change a payment schedule in worksheet 1, it picks up the correct amount from worksheet 2?
I know I'm going to kick myself when I see the answer. Thank you very much.
Worksheet #1
In A1 I have a payment schedule #
In B1 I want the payment amount associated with the payment schedule listed in A1.
etc, etc, theres over 300 rows with 11 different payment schedules.
Worskeet #2
In A1 I have the payment schedule #
in A2 I have the payment amount
etc, etc. Theres 11 different payment schedules.
How do I make it work automatically so if I change a payment schedule in worksheet 1, it picks up the correct amount from worksheet 2?
I know I'm going to kick myself when I see the answer. Thank you very much.