create VBA code/loop that will organize data from the batch input page, and output it to the batch output sheet as formatted in tbe second photo (see real excel sheet at the bottom page)

case, the Batch Estimates. OT often wants to estimate batches of trips. In this program should take all of the tours shown as inputs on the [Batch Input) tab, estimate them one at time, and write the results to the [Batch Output) tab. To estimate all trips within a batch, the user presses the Run Batch button on the [User Form) tab. The [Batch Input] tab. Figure 2 explains the data on the (Batch Input) tab. All passenger inputs for Batch Estimates will be between 20 and 120 people. Figure 2: (Batch Input] Tab Name B 1/5/2017 Trip Date 1 Davis Schools 2 61 3 6 4 5 Willie Wrestling Number of people Hours 1/6/2017 The (Batch Output] tab. Figure 3 shows how your program should organize the outputs on the [Batch Output) tab. The [Batch Output] tab. Figure 3 shows how your program should organize the outputs on the [Batch Output] tab. Figure 3: [Batch Output] Tab. B D E Customer Date People Hours PPBR EHP 2 Davis Schools 1/5/2017 61 6 $10.00 25% 3. Willie Wrestling 1/6/2017 20 4 $10.00 25% Dahle Reunion 1/6/2017 55 7 $1000 254 5. Stanfield Group 1/7/2017 120 10 $10.00 251 instructions Ur Farm Batch input Batch Output H 1 NS NL BP 1 1 $610.00 1 0 $200.00 0 1 $550.00 0 2 $1 200 00 OH 1 0 2 4 K OC $152 50 $782.50 $0.00 $200.00 $275.00 $825.00 $1,200.00 $2.400.00 HEADW insert Draw Page Layout Formulas Data Review XYZ Record Macro Visual Macros Uso Relative References Basic KAL Add-ins Excel Add-ins Button Group Combo Box Kelse Box Open recovered workbooks? Your recent changes were saved. Do you want to co X fx Davis Schools A1 B D E F 1/5/17 1 Davis Schools Sle 2 61 36 4 1/6/17 6 Willie Wrestling 7 20 84 Wed 1/6/17 10 Dahle Reunion 11 55 12 7 Wed 15 1/7/17 16 Stanfield Group 17. 120 18 10 Wed 20 Marriott Hotels 1/9/17 21 50 22 6 User Form Batch Input Batch Output Grading Criteria Ready Wee Lazua uvuus Visible TU. -1 - xSheetVisible Due Date: Mar 3 Doint 3,412 ARAR case, the Batch Estimates. OT often wants to estimate batches of trips. In this program should take all of the tours shown as inputs on the [Batch Input) tab, estimate them one at time, and write the results to the [Batch Output) tab. To estimate all trips within a batch, the user presses the Run Batch button on the [User Form) tab. The [Batch Input] tab. Figure 2 explains the data on the (Batch Input) tab. All passenger inputs for Batch Estimates will be between 20 and 120 people. Figure 2: (Batch Input] Tab Name B 1/5/2017 Trip Date 1 Davis Schools 2 61 3 6 4 5 Willie Wrestling Number of people Hours 1/6/2017 The (Batch Output] tab. Figure 3 shows how your program should organize the outputs on the [Batch Output) tab. The [Batch Output] tab. Figure 3 shows how your program should organize the outputs on the [Batch Output] tab. Figure 3: [Batch Output] Tab. B D E Customer Date People Hours PPBR EHP 2 Davis Schools 1/5/2017 61 6 $10.00 25% 3. Willie Wrestling 1/6/2017 20 4 $10.00 25% Dahle Reunion 1/6/2017 55 7 $1000 254 5. Stanfield Group 1/7/2017 120 10 $10.00 251 instructions Ur Farm Batch input Batch Output H 1 NS NL BP 1 1 $610.00 1 0 $200.00 0 1 $550.00 0 2 $1 200 00 OH 1 0 2 4 K OC $152 50 $782.50 $0.00 $200.00 $275.00 $825.00 $1,200.00 $2.400.00 HEADW insert Draw Page Layout Formulas Data Review XYZ Record Macro Visual Macros Uso Relative References Basic KAL Add-ins Excel Add-ins Button Group Combo Box Kelse Box Open recovered workbooks? Your recent changes were saved. Do you want to co X fx Davis Schools A1 B D E F 1/5/17 1 Davis Schools Sle 2 61 36 4 1/6/17 6 Willie Wrestling 7 20 84 Wed 1/6/17 10 Dahle Reunion 11 55 12 7 Wed 15 1/7/17 16 Stanfield Group 17. 120 18 10 Wed 20 Marriott Hotels 1/9/17 21 50 22 6 User Form Batch Input Batch Output Grading Criteria Ready Wee Lazua uvuus Visible TU. -1 - xSheetVisible Due Date: Mar 3 Doint 3,412 ARAR