+ Reply to Thread
Results 1 to 2 of 2

Sorting with a macro puts staff with $0 at bottom. How to eliminate blank cells???

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    27

    Sorting with a macro puts staff with $0 at bottom. How to eliminate blank cells???

    Hi all.
    I have attached my speadsheet I have been working on. I have created a macro button that you hit to autosort the sales of each staff member from top to bottom ( based on total %, the "n" column). But when I do the sort the staff members that have 0% are put way down in 40th place instead of 14th and 15th where they should be.
    I cant touch any of the tabs except for the main page.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Sorting with a macro puts staff with $0 at bottom. How to eliminate blank cells???

    Replace your current code with the below one

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Keeping blank rows at the bottom while sorting a 300 row spreadsheet
    By badiller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2013, 02:13 PM
  2. Macro to sort blank cells to bottom
    By coopman64 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2012, 02:21 AM
  3. [SOLVED] Help with a macro to delete empty (but not blank) cells OR sort blanks to the bottom
    By Cyali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 09:04 PM
  4. VBA Macro to eliminate cells with a blank value
    By paulxl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2012, 10:23 AM
  5. macro that puts a formula in a group of cells then goes and values those cells
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2007, 02:00 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1