select and sort macro

Duffer2468

New Member
Joined
Sep 8, 2014
Messages
8
I am having some serious problems with what i thought would be an easier venture.
I need a macro that would select all the cells with data actually in them (not cells the sheet thinks is active) in columns A & B then sort then by column B (but never incude blank cells) As well the list size in the A&B column with change in the total number of rows. I tried the macro recorder but since it is absolute it only sorts what I selected manaually. I tried a macro to select all data and while that kind of works (once) cause if you change the size of data in A&B or touch a cell ousite the data area it remembers those cells and incudes them. Not sure if I am making any sense. Been a real rough week .
Thanks for looking
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,114,652
Messages
5,549,210
Members
410,905
Latest member
Extjel
Top