Write a sub using VBA in Excel:

Lets read the sales reps and amount from the Ohio Sales sheet and save them in parallel arrays Lets use dynamically sized arrays Then, lets look in the array for sales rep for Cochran and report the total sales for CochranIf we find it, report the total sales amount in a message box If we dont find it, report the fact that this Sales Rep had no sales in Ohio