Auto Sort 1 column and select data

  • Thread starter Thread starter kookie
  • Start date Start date
K

kookie

I have found many solutions that come very close to the requirements I need
for an auto sort and select. I like the formula posted on 1/13/2009. then
found issues if numbers stored as test. was able to overcome that issues by
adding INT the the original formula. I have a randon amount of data always in
35 columns. Once column f is different, it contains ids, unique and do not
repeat. I could have 6 rows of data or 3000 rows.

I populate this worksheet using an IF formula, and this formula is repeated
all 3000 rows for each column. IF(source <>"",source,"")

even though the cell is empty using Ctrl + Shift down arrow selects all 3000
rows.

Doing a simple ascending sort places blank cell at top.

What I need is to sort column F and select on ly the rows that are populated
with data.

Can this be done?
 
You have formulas that return "" so the cells are not
empty...............just look blank.

Perhaps you could use the Autofilter to filter fo non-blanks.

Now sort the visible cells.


Gord Dibben MS Excel MVP
 
Perfect, I finally came to that conclusion, so now my question is, how can i
automate this. I know If today I have 200 records and i turn on the filter to
only return records, and tomorrow I have 2000 records I have to manipulate
the filter. Is there a way to create an autofilter that refreshes when the
sheet is active?

thanks
Kookie

/////////////////////////////////
 
You could turn on the macro recorder and see what you get.

After making a stab at that, if still having questions, post back with the
code your recorder came up with.

Most times the recorder code is less than optimal.


Gord
 
Hi,

This depends on the version of Excel you are using - In Excel 2007 simple
press Ctrl+Alt+L, in 2003 you probably will need a macro.

If this helps, please click the Yes button,

Cheers,
Shane
 
Back
Top