parse inputs to display outputs from an excel file through VBA

[Prachijain]

Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data from, it's all from the excel filename where I need to parse the data and get the outputs for different test cases and later math the results with an api. Below are my inputs and outputs of my worksheet. Any help would be greatly appreciated. Thank You.

Excel 2010

	C	D	E	F	G
1	Input Fields	Values		Output Fields	Values
2	input_BirthDate	6/5/1954		output_Range_Age1	70
3	input_HireDate	8/1/2013		output_Range_Age2
4	input_Gender	F		output_Range_Age3
5	input_AnnualPlanComp	50224		output_Range_Age4
6	input_EmployeeClass	Regular School District		output_Range_Age5
7	input_AnnualPayGrowth	1		output_Range_Custom	64
8	input_MarketPerformance	Average		output_Balance_Age1	$ -
9				output_Balance_Age2	$ -
10	input_PVD	70		output_Balance_Age3	$ -
11	input_NRA	62		output_Balance_Age4	$ -
12	input_MBAA	65		output_Balance_Age5	$ -
13	input_Custom_BCD	64		output_Balance_Custom	$ -
14	input_Custom_TermAge	64		output_Balance_LumpSum	$ -
15
16	input_RemainingElections	1		output_CurrentAge	63
17				output_MinAgeTerm	64
18	input_Pre2011ServiceYears	4		output_MaxAgeTerm	80
19	input_ProjectedServiceYears	11		output_MinAgeBCD	70
20	input_ProjectedBenefitAmount	7028.58		output_MaxAgeBCD	65
21	input_DROP_LumpSum	0
22				output_DROP_Question	FALSE
23	input_ProjBuyBackABO			output_DROP_Years
24	input_DateABO	2/28/2018		output_DROP_Start
25	input_ProjectedABO	103461.51		output_DROP_1stYear
26	input_ProjectedAAL	48696		output_DROP_Accumulation
27	input_DateAAL	3/31/2018		output_DROP_AccumulationAnnuity
28	input_InvestmentBalanceTBA	0		output_DROP_TotalAnnuity
29	input_CurrentABO	80772.6		output_DROP_COLA	1.09%
30
31				output_BuyBack_PP	$ 48,696.00
32				output_BuyBack_Payment	$ 48,696.00
33				output_BuyBack_IP_AddOn	$ 2,626.60
34				output_BuyBack_TotalAnnuity	$ 2,626.60

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Inputs Outputs​

Worksheet Formulas Cell Formula G2 =Model!B33 G3 =Model!B34 G4 =Model!B35 G5 =Model!B36 G6 =Model!B37 G7 =Model!B38 G8 =Model!B45 G9 =Model!B46 G10 =Model!B47 G11 =Model!B48 G12 =Model!B49 G13 =Model!B50 G14 =Model!B44 G16 =Model!B20 G17 =output_CurrentAge+1 G19 =IF(input_Custom_TermAge>input_MBAA,input_Custom_TermAge,MAX(output_MinAgeTerm,input_PVD)) G20 =MAX(input_Custom_TermAge,input_MBAA) G22 =Model!G125 G23 =Model!G131 G24 =Model!G133 G25 =IF(output_DROP_Question,input_ProjectedBenefitAmount,"") G26 =IF(output_DROP_Question,Model!F87,"") G27 =IF(output_DROP_Question,Model!B86,"") G28 =IF(output_DROP_Question,Model!B87,"") G29 =ROUND(output_Global_DROP_COLA/100,4) G31 =Model!E100 G32 =Model!E101 G33 =IF(Model!E103<0,0,Model!E103) G34 =IF(output_BuyBack_IP_AddOn=0,Model!B50,Model!B51) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Workbook Defined Names Name Refers To input_Custom_TermAge ='Inputs Outputs'!$D$14 input_MBAA ='Inputs Outputs'!$D$12 input_ProjectedBenefitAmount ='Inputs Outputs'!$D$20 input_PVD ='Inputs Outputs'!$D$10 output_BuyBack_IP_AddOn ='Inputs Outputs'!$G$33 output_CurrentAge ='Inputs Outputs'!$G$16 output_DROP_Question ='Inputs Outputs'!$G$22 output_Global_DROP_COLA ='Inputs Outputs'!$J$5 output_MinAgeTerm ='Inputs Outputs'!$G$17 PVD ='Inputs Outputs'!$D$10 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data from, it's all from the excel filename where I need to parse the data and get the outputs for different test cases and later math the results with an api. Any help would be greatly appreciated. Thank You.Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data from, it's all from the excel filename where I need to parse the data and get the outputs for different test cases and later math the results with an api. Any help would be greatly appreciated. Thank You.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ay-outputs-applying-formulas.html#post5067426

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.