Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default hci: restore a block of data to original input row sequence ?

Is there a way excel captures the row number associated with data where it
was originally input, in order to resort it back to the original input
sequence after saving the file following manipulation?

My data has no logical resort field such as date sequence etc. on which to
do a block sort.

The only way I know is to create a column and manually enter the number
which corresponds to the input row number. This allows me to block sort the
data back to its original sequence. (Row 1 to 1200 is a lot of typing and
space)

I suspect Excel keeps some information about the row # of the cell used when
the data was originally input.
There must be an Excel function such as @InputRow which automatically places
the reference number of each row at the time data is input

Any suggestions or help is appreciated.

Jocko_MacDuff116
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
Input original save date djarcadian Excel Discussion (Misc queries) 1 June 2nd 06 11:01 PM
How do I restore original Pivot Table data? Andrew C Excel Discussion (Misc queries) 5 January 5th 06 07:21 AM
Auto save replaced my original file and now I need the original? Hols Excel Discussion (Misc queries) 1 August 15th 05 11:34 PM
How do I restore my original excel settings to default? Patsy Excel Discussion (Misc queries) 1 February 14th 05 02:46 AM
How to add a button to restore all altered cells original values? Dawnybros Excel Discussion (Misc queries) 2 December 2nd 04 05:35 PM


All times are GMT +1. The time now is 02:33 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"