Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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/2015Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started