Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel 2000 VBA problem -- sorting values in subtotaled column

I copied a data table from the internet into an Excel 2000
spreadsheet. I have done this before. Last time, I
experienced trouble, and someone sent me a macro that
cleans up the column being subtotaled so that Excel can
perform calculations. This worked, and I was able to sort
the column after running the subtotal function, so I could
order the subtotals in descending order.
For some reason, my macro isn't working! I have opened the
macro and everything seems to be accurate for the columns
in my new spreadsheet, but.... it still won't let me sort
the subtotals.
Please help! I can send along the file with the macro if
it will help -- drop me an email and I'll reply.
Thank you!
Pemily

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Subtotaled information chris Excel Discussion (Misc queries) 3 October 4th 07 10:32 PM
Problem sorting in Excel 2000 vs. 2003 David P. Excel Discussion (Misc queries) 3 April 26th 07 03:56 AM
Sorting subtotaled amounts in excel ep New Users to Excel 2 April 11th 06 05:58 PM
sorting problem in excel 2000 inenewbl Excel Discussion (Misc queries) 1 June 13th 05 04:48 AM
Show values from non-subtotaled columns when doing a sub-total? Jim Excel Discussion (Misc queries) 4 February 5th 05 09:13 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"