Macro for alphabetizing... more difficult that it sounds

Hello Nickster64,

Do you ever have duplicate names in the same column? How many days will need to be sorted at time?

Sincerely,
Leith Ross

Hi
try this macro. Don't add grand total. the macro will do it for you.
Ravi

Do you ever have duplicate names in the same column? How many days will need to be sorted at time?

Leith,

No, there will never be duplicate names in the same column. At max only 2 days will need to be sorted at a time -- previous day, and current day.

try this macro. Don't add grand total. the macro will do it for you.

ravishankar,

Your macro worked great! I have a few questions though...
(1) Why was Williams, Ace was left out after I ran the macro? (in the 12/11/08 column)

(2) Would this macro work with any number and combination of names in either list?

(3) My data comes from a pivot table where the "Grand Total" is automatically generated and included in the names list. Could your macro treat 'Grand Total' as another name value which needs to be arranged side-by-side? (I tried to 'comment out your Grand Total code within your macro but when I ran it Grand Total was just deleted all together)

(4) Finally, I am self-teaching myself Excel VB code and have learned much from this site and people's explanations. Could you provide me an explanation with why you chose the codes that you used for this macro so I may learn?

Best,

Nick

Hello Nick,

The attached workbook contains 2 modules. Each module holds 1 macro. The macros are FindLastRow and ReformatData. This macro will work with the day columns being of unequal length. The grand total lines are added as the last line of the reformatted data. You can change the names of the worksheets and the starting row of data in the macro to match your actual setup. These variables are marked in red. A button has been added to the "Before" worksheet to run the macro.

Find Last Row Macro

Please Login or Register  to view this content.

Reformat Data Macro

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,

Your macro works excellent, thanks! I am going to break this down to understand it and learn from it.

Nick

Originally Posted by Leith Ross

You can change the names of the worksheets and the starting row of data in the macro to match your actual setup. These variables are marked in red.

Leith, in the actual workbook I use just 1 worksheet and do not have a BEFORE or AFTER sheets. This worksheet's name is the current date "dd-mm-yy". I figured I could replace your red variables with 'Active.Sheet' code but it's not working.

What would you recommend?

Thanks,

Nick

Perfect. Thank you all,

Nick