Sorting with blank rows

[tucsondonpepe]

Hi,

I need help sorting the table with VBA code.

There are four rows and three columns of data.
The sort is on Last Name, then First Name

When I use the standard sort procedure, the blank rows are listed as rows 1 and 2.

I appreciate the help.

Joe

 

[Joe4]

I don't understand what your question/concern is.
Whenever I sort, the blank rows always appear at the bottom, as expected.

Can you show us three images:
- the BEFORE image of what your data looks like before sorting
- the AFTER image of what your data looks like after sorting
- your desired result image

 

[tucsondonpepe]

Thank you for looking at this.

I hope the images show the problem.

The last image is the desired output.

 

[Joe4]

A few things to check:

- Are those blank fields REALLY blank, or is there something actually in them?
For example, if G6 is one of the apparent blank cells, enter this formula in any unused blank cell anywhere on the sheet and tell us what it returns:

=LEN(G6)

- In your Last Name field, are there any spaces or characters at the beginning of the string BEFORE the last name like "Lange"?

 

[tucsondonpepe]

I checked the fields for spaces before and after the entry and found none.

I inserted the formula and the result is 0.

Notice that my initials, JL, appear to the right of "Lange". I do not know what that means.

 

[Joe4]

Just to double-check, you are doing this in Excel, right? Not some other program?

And you are limiting your sort just to columns G, H, and I, right?

Why do you need a Custom Sort, instead of just using the basic built-in Sort feature?

If I try to recreate it, this is what I have:

Initial data:

Basic sort rules:

Results:

 

[tucsondonpepe]

I am using Excel. However, the file is on OneDrive and the only option available is Custom Sort.

My goal is to write a VBA macro to perform the sort. Can you help with this? Thank you.

Joe

 

[Joe4]

I don't believe you can use Excel VBA on OneDrive.
Files in OneDrive can contain macros/VBA, but you cannot run them unless you download the file to a local drive.

 

[tucsondonpepe]

Joe4,

Thank you very much for your help.

Joe

 

[Joe4]

You are welcome.