Solved

How to sort columns and delete rows with 0

Posted on 2014-10-23
2
127 Views
Last Modified: 2014-10-23
I have a an excel spreadsheet that has data that changes every month. I need a macro or VB script that will sort all data by column c with the largest number to  top and then delete any row with "0". Is this possible. I have upload a sample of my spreadsheet.
Thank you.
Test.xlsx
0
Comment
Question by:jodyreid
2 Comments
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 40399797
Try this example
Test.xlsm
0
 

Author Closing Comment

by:jodyreid
ID: 40399901
Thank you. This worked great.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question