EXCEL SORTING TWO COLUMNS

%3CLINGO-SUB%20id%3D%22lingo-sub-3105412%22%20slang%3D%22en-US%22%3EEXCEL%20SORTING%20TWO%20COLUMNS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3105412%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20setting%20up%20a%20macro%20to%20sort%2013%20sheets%20simultaneously.%20Each%20sheet%20is%20for%20a%20different%20month%20and%20there%20is%20a%20YTD%20sheet.%20Each%20sheet%20has%20a%20room%20to%20input%2050%20salespeople%20in%20the%20first%20column%20and%20their%20gross%20sales%20in%20the%20second%20column.%20Now%20there%20are%2042%20salespeople%20so%20some%20of%20the%20lines%20are%20blank.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20when%20I%20sort%20by%20name%20it%20moves%20the%20empty%20spaces%20to%20the%20top.%20I%20need%20the%20empty%20spaces%20at%20the%20bottom.%20The%20worksheet%20does%20have%20headers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3105412%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I am setting up a macro to sort 13 sheets simultaneously. Each sheet is for a different month and there is a YTD sheet. Each sheet has a room to input 50 salespeople in the first column and their gross sales in the second column. Now there are 42 salespeople so some of the lines are blank. 

The problem is that when I sort by name it moves the empty spaces to the top. I need the empty spaces at the bottom. The worksheet does have headers.worksheetworksheet

0 Replies