Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Access Patterns Database Interactions In Object Oriented Applications

Authors: Clifton Nock

1st Edition

0321555627, 978-0321555625

More Books

Students also viewed these Databases questions