Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 136
  • Last Modified:

How to sort columns and delete rows with 0

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
jodyreid
Asked:
jodyreid
1 Solution
 
jpaulinoCommented:
Try this example
Test.xlsm
0
 
jodyreidAuthor Commented:
Thank you. This worked great.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now