You are welcome! Thanks for the feedback!
Stefi

€žGazz_85€� ezt Ã*rta:

Cheers guys,

so simple dont know why i didn't think of that!!

much appreciated

"Stefi" wrote:

One way is to use a helper column: before sorting fill it with =ROW(), Copy
and PasteSpecialValues in the same column to save original row Nos, and sort
by helper column to return to the original order!

Regards,
Stefi

€žGazz_85€� ezt Ã*rta:

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