Question: the macro must be done through VBA (visual basic aid) on excel. thank you 1 Create a macro to extract all of the data from

 the macro must be done through VBA (visual basic aid) on

the macro must be done through VBA (visual basic aid) on excel. thank you

1 Create a macro to extract all of the data from the year 2015 and copy it into a separate block. 2 create a table that displays the minimum concentration for each month in the copyed data. 3 Add a button to run the macro. 5 Date Concentration (mcg/I) 6 2/21/2015 79/2/2015 8 1/17/2015 9 4/30/2015 01/1/2016 11 10/31/2015 12 8/26/2016 13 12/6/2016 14 5/19/2015 15 10/21/2016 16 6/22/2016 17 1/13/2016 18 4/4/2015 0.824 5.099 0.427 1.594 5.278 9.616 7.474 5.696 1.606 4.598 8.663 6.943 0.87 8.657 8.65 2.725 1.005 19 11/6/2015 20 8/12/2016 21 7/6/2015 22 3/17/2015

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!