Solved

How to sort columns and delete rows with 0

Posted on 2014-10-23
2
126 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

770 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