LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Returning to original view.

Hi,

i have a table that logs issues. each issue is assigned a number, however
the numbers also contain a letter such as R1,R2,M1,M2,ect.

I have written some macros to filter and sort the issues for various
reports. However i want to be able to turn the table to its original state.
how would i do this???

i have tried to sort the data in asscending order, but it puts it in
alphabetical order.

for example:

the original list is

R1
R2
M1
C1
M2
R3

I want the data to return to this not

C1
M1
M2
R1
R2
R3

Any help?????
 
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
Returning to multiple data fields pivot table view ohadn77 Excel Worksheet Functions 0 April 1st 09 04:52 PM
How do I view color onscreen (it shows up in print view only) janice Excel Discussion (Misc queries) 1 August 15th 06 07:32 PM
Trouble returning to Normal view after inserting a header and foot Eazy-E Excel Worksheet Functions 0 July 26th 06 11:58 PM
column is hidden in normal view but not print view Bianca Excel Worksheet Functions 2 June 23rd 06 08:38 AM
Auto save replaced my original file and now I need the original? Hols Excel Discussion (Misc queries) 1 August 15th 05 10:34 PM


All times are GMT +1. The time now is 01:47 AM.

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"