Question: Please Help me right a working VBA code following the instructions below!!! ***Please do not use a code already post on chegg they do not

Please Help me right a working VBA code following the instructions below!!!

***Please do not use a code already post on chegg they do not work!***

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

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 Accounting Questions!