I attempted the 2007 custom sort function but I am working on a spreadsheet
with over 5000 rows. Does this mean I have to create a custom sort with 5000
entries? I am confused. The other aspect to this is I have header rows,
actually have 3 rows of header data...which may affect how this function
works. I think code is the answer....please help!
--
Holly


"HOLLY" wrote:

Hi,
I am using excel 2003 to write the code but many of our users have been
upgraded to 2007. I can look at the option you mention on an 07 machine, and
as long as that sort can be preset to automatically appear to other users,
then it would work. The reason I wanted code is because most of our users
are not computer savvy at all, zilch. I have already built a macro that
refreshes the entire workbook which pulls data from several sources etc. The
main worksheet that I need this code for is huge. Copy and paste just is not
an option.
--
Holly


"Matthew Herbert" wrote:

Holly,

Which version of Excel are you using? I'm using Office 2007 and it allows
you to apply a custom sort to data that has been filtered.

As a quick, general thought, you could copy the visible data to another
worksheet and then sort the copied data. If you customize the toolbar (or
QAT), you can find a control called "Select Visible Cells" that will allow
you to select only visible data.

Let me know if this helps.

Best,

Matthew Herbert

"HOLLY" wrote:

We have a large worksheet used by many users that may have various filters on
various columns at any given time. Column A contains data 0 thru 8. I need
code to add to a macro that will sort the worksheet by the VISIBLE data in
Col A as follows: 0 must always be at the top, then the first visible row
with a 1 would be next, then the first visible row with a 2, then the next
row a 1, then a 2, etc...the remaining rows with 3-8 may just show in
ascending order all 3's, all 4's etc...so that column A will look like
0,0,0,1,2,1,2,1,2,1,2,3,3,3,3,4,4,4,....etc
This would be a great help.
--
Holly