J
Jocko_MacDuff116
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
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