Macro To Goalseek After Certain Conditions Are Met

I'm trying to create a macro to Goalseek after certain conditions are met and then loop until other conditions are met. In my worksheet, the reference cells for the macro are as follows:

a. Range (U94:DL94) as Cash Available
b. Range (U95:DL95) as Distribution
c. Range (U96:DL96) as Monthly Cashflow
d. Range (U98:DL98) as the IRR calculation. IRR Calculation (If AT98 is active cell) = (1+IRR($U$96:AT96,0.01))^12-1. If AU98 is active cell, then IRR Calculation = (1+IRR($U$96:AU96,0.01))^12-1), etc.

I need the macro to do the following:

1) If value in range Cash Available > 0 and value in range IRR < 0.08, then goalseek
(set cell = (range IRR), Goalseek = 0.08, Changing cell = (range Distribution)

2) If Goalseek result in range Distribution < value in range Cash Available, set cell equal to value in range Cash Available.

3) I need GoalSeek to loop until value in range Distribution > 0 and whatever cell in range IRR = 0.08.

4) After first cell in range IRR = 0.08, I need the macro to start again on the same named ranges but for different rows lower down on the spreadsheet and do the same loop, but this time for range IRR(2) = 0.15.