Question
Please help me write a VBA Macro with the following requirements!!! Write a VBA macro referencing the data on the VBA Problem Starting Data tab.
Please help me write a VBA Macro with the following requirements!!!
Write a VBA macro referencing the data on the VBA Problem Starting Data tab. Your macro should do the following. (Note: You should be able to complete all these tasks by running your macro one time. You will lose points if you must run your macro multiple times to complete the tasks.) a. Flip the sign for any negative values in the Amount Requested column. i. Ex/ -24,000 24,000 b. Highlight columns A K for each row according to these rules. (If everyone in your group is color-blind, please let me know.) i. The rows for Amounts Requested less than 3,000 should be green. ii. The rows for Amounts Requested less than 19,000 but more than 2,999 should be blue. iii. The rows for Amounts Requested more than 18,999 should be orange. c. Delete any record with an absolute value of Amount Requested more than 25,000. (i.e. more than 25,000 or less than -25,000) d. The macro should be triggered from a button located on the VBA Setup Instructions tab. e. Once complete, the macro should select cell A1 on the VBA Problem Starting Data tab.
Step 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