Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Input original save date | Excel Discussion (Misc queries) | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
How do I restore my original excel settings to default? | Excel Discussion (Misc queries) | |||
How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) |