View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gazz_85[_2_] Gazz_85[_2_] is offline
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?????