Microsoft Excel VBA – Post Training Activity 2

In your first macro which you created in activity 1, we are adding up extra flexibility in your existing macro. I want your macro to get the report for any region of user choice, follow the below steps to achieve it.

  1. You need to get the region name from the user through an input box
  2. Store that value in a variable
  3. Use that variable value in the filtering criteria to generate the report

Best of Luck!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.