Results 1 to 6 of 6

Thread: VBA Message box to display column titles based upon totals

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBA Message box to display column titles based upon totals

    Hi there,

    I have a spreadsheet that contains 9 employees, and their sales in thousands over a period of 10 years. Their total sales over the 10 year period are totaled at the bottom. What I am looking to do is have a message box that pops up and displays the names of the employees who have total sales over 500. So basically the code will look for values over 500 in the bottom row, and then take the corresponding names of the employees and display it in a single message box. I am new to VBA, and have Googled around on how to get started with this but I have not found anything. I have attached my worksheet below, any help is greatly appreciated.


    Employee Sales.xlsm
    Last edited by gratefulwork; 10-24-2018 at 11:04 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •