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

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,295
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top