Auto Sort 1 column and select data

[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?

 

[Gord Dibben]

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

 

[kookie]

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

/////////////////////////////////

 

[Gord Dibben]

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

 

[Shane Devenshire]

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