Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?????
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Returning to original view.

You need a helper column that simply contains a series of sequence numbers
that represent the original entry order. You could write a short macro
attached to the worksheet's _Change() event that would get the current
maximum value in that helper column, and if the cell in the helper column on
the row with the change is empty, then put the next sequence number into the
helper column. Code might look something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
'add next sequence number to column A when
'a change takes place in a single cell
'on the sheet below row 1
'and not in column A
If Target.Column < 1 And Target.Row 1 And _
Target.Cells.Count = 1 Then
If IsEmpty(Range("A" & Target.Row)) Then
Range("A" & Target.Row) = _
Application.WorksheetFunction.Max(Range("A:A")) + 1
End If
End If
End Sub

"Gazz_85" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default Returning to original view.

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Returning to original view.

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default Returning to original view.

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

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
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 02:23 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"