View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jocko_MacDuff116 Jocko_MacDuff116 is offline
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