Complex Goal Seek or Solver Solution

[ShanaVT]

Hello, I need to solve for several cells to equal the same value based on changing a certain set of values. I have tried to use goal seek to do each one individually but I can't get it to work to solve for the whole group. Below is the data set that starts with P7 in cell B2 and DWC AR Billed in A2 and then that data set repeated to the right in red font showing the formulas. The values in blue font are what I need to solve for - I need all 4 of the DWC values to = 42.3 (P7, P8, P9 and Q3) and similarly I need all the DSO numbers to equal 66.0. The only values I can change to get the DWC and DSO to be 42.3 andf 66.0 respectively are the numbers in pink font. And there are ranges for what those numbers can be below. Is there anyway to use solver to get to an answer with this criteria or perhaps a macro I can could run? Thanks in advance for any help!

[TABLE="width: 330"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]DWC AR Billed[/TD]
[TD]Range = 115,000 - 150,000[/TD]
[/TR]
[TR]
[TD]DWC AR Unbilled[/TD]
[TD]Range = 175,000 - 250,000[/TD]
[/TR]
[TR]
[TD]DWC Accounts Payable[/TD]
[TD]Range = 75,000 - 130,000[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1131"]
<colgroup><col><col span="3"><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]P7[/TD]
[TD]P8[/TD]
[TD]P9[/TD]
[TD]Q3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DWC AR Billed[/TD]
[TD] 125,000[/TD]
[TD] 121,825[/TD]
[TD] 126,363[/TD]
[TD] 126,363[/TD]
[TD][/TD]
[TD] 125,000[/TD]
[TD] 121,825[/TD]
[TD] 126,363[/TD]
[TD] =D2 [/TD]
[/TR]
[TR]
[TD]DWC AR Unbilled[/TD]
[TD] 204,469[/TD]
[TD] 227,483[/TD]
[TD] 218,235[/TD]
[TD] 218,235[/TD]
[TD][/TD]
[TD] 204,469[/TD]
[TD] 227,483[/TD]
[TD] 218,235[/TD]
[TD] =D3 [/TD]
[/TR]
[TR]
[TD]DWC AR Retention[/TD]
[TD] 2,091[/TD]
[TD] 1,916[/TD]
[TD] 1,848[/TD]
[TD] 1,848[/TD]
[TD][/TD]
[TD] 2,091[/TD]
[TD] 1,916[/TD]
[TD] 1,848[/TD]
[TD] =D4 [/TD]
[/TR]
[TR]
[TD]DWC Accounts Receivable[/TD]
[TD] 331,560[/TD]
[TD] 351,224[/TD]
[TD] 346,446[/TD]
[TD] 346,446[/TD]
[TD][/TD]
[TD] =SUM(B2:B4) [/TD]
[TD] =SUM(C2:C4) [/TD]
[TD] =SUM(D2:D4) [/TD]
[TD] =D5 [/TD]
[/TR]
[TR]
[TD]DWC Accounts Payable[/TD]
[TD] 103,459[/TD]
[TD] 110,520[/TD]
[TD] 108,804[/TD]
[TD] 108,804[/TD]
[TD][/TD]
[TD] 103,459[/TD]
[TD] 110,520[/TD]
[TD] 108,804[/TD]
[TD] =D6 [/TD]
[/TR]
[TR]
[TD]DWC Def Rev[/TD]
[TD] 15,523[/TD]
[TD] 15,523[/TD]
[TD] 15,523[/TD]
[TD] 15,523[/TD]
[TD][/TD]
[TD] 15,523[/TD]
[TD] 15,523[/TD]
[TD] 15,523[/TD]
[TD] =D7 [/TD]
[/TR]
[TR]
[TD]DWC Accr Res[/TD]
[TD] 79[/TD]
[TD] 79[/TD]
[TD] 79[/TD]
[TD] 79[/TD]
[TD][/TD]
[TD] 79[/TD]
[TD] 79[/TD]
[TD] 79[/TD]
[TD] =D8 [/TD]
[/TR]
[TR]
[TD]DWC Accrued Liabilities[/TD]
[TD] 15,602[/TD]
[TD] 15,602[/TD]
[TD] 15,602[/TD]
[TD] 15,602[/TD]
[TD][/TD]
[TD] =B7+B8[/TD]
[TD] =C7+C8[/TD]
[TD] =D7+D8[/TD]
[TD] =D9 [/TD]
[/TR]
[TR]
[TD]Total Net Working Capital[/TD]
[TD] 212,500[/TD]
[TD] 225,103[/TD]
[TD] 222,041[/TD]
[TD] 222,041[/TD]
[TD][/TD]
[TD] =B5-B6-B9[/TD]
[TD] =C5-C6-C9[/TD]
[TD] =D5-D6-D9[/TD]
[TD] D10 [/TD]
[/TR]
[TR]
[TD]Prime Sales[/TD]
[TD] 175,827[/TD]
[TD] 149,004[/TD]
[TD] 152,844[/TD]
[TD] 477,676[/TD]
[TD][/TD]
[TD] 175,827[/TD]
[TD] 149,004[/TD]
[TD] 152,844[/TD]
[TD] =SUM(B11:D11) [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] DWC [/TD]
[TD] 42.3[/TD]
[TD] 42.3[/TD]
[TD] 40.7[/TD]
[TD] 42.3[/TD]
[TD][/TD]
[TD] =B10/B17 [/TD]
[TD] =C10/C17 [/TD]
[TD]=D10/D17 [/TD]
[TD] =E10/(SUM(B11:D11/SUM(B16:D16)) [/TD]
[/TR]
[TR]
[TD] DSO [/TD]
[TD] 66.0[/TD]
[TD] 66.0[/TD]
[TD] 63.5[/TD]
[TD] 66.0[/TD]
[TD][/TD]
[TD] =B5/B17 [/TD]
[TD] =C5/C17 [/TD]
[TD] =D5/D17 [/TD]
[TD] =E5/(SUM(B11:D11/SUM(B16:D16)) [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Days in Period[/TD]
[TD] 35[/TD]
[TD] 28[/TD]
[TD] 28[/TD]
[TD][/TD]
[TD][/TD]
[TD] 35[/TD]
[TD] 28[/TD]
[TD] 28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Prime Sales/Days[/TD]
[TD] 5,024[/TD]
[TD] 5,024[/TD]
[TD] 5,024[/TD]
[TD][/TD]
[TD][/TD]
[TD]=B11/B16[/TD]
[TD]=C11/C16[/TD]
[TD]=D11/D16[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]