Use Product Sales.xlsx to create a macro to sort the product by the total sales (in a decreasing order) and report the results in a new worksheet named Summary.

Use this link to access the excel sheet and if possible share the excel file using mediafire link on completion(100% thums up for answer)

http://www.mediafire.com/file/xxunxzms45jxo08/assigni_ii_product_sales_1_.xlsx

Requirements:

You can use macro recorder to help in programming but do not only use the macro recorder.

In the new worksheet Summary the following two columns are required:

Product

Total Sales (in decreasing order of total sales)

The macro should also:

Calculate the runtime

Prompt a dialog box showing the time in seconds. The message will be This macro ran in __ seconds.

Create a list of charts for the top 50 products and display these charts in another worksheet named Charts.)