Hello - I need an out-of-the-box solution for this one!
I have a template that's set up as a table with columns A through T. The user simply copies their data set from a report result, then pastes that into cell A2. The table then expands to include their data set. The users want to do a lot of sorting, but then return the data set to its original order, so I need to add a Key field. I'd like a key field that auto-populates in column T when the table expands with the data set. The problem is, if I use a function (such as =Row-1 or =Cell Above Value + 1), the values will always stay 1,2,3,+, regardless of the sort, as the formula is tied to the cell's location, rather than the data set. Hence, the field isn't a key field at all.
Does anyone have an idea of how to create this key field that will auto-populate itself but still sort with the data? I'm at a loss!
*No macros, please*
I have a template that's set up as a table with columns A through T. The user simply copies their data set from a report result, then pastes that into cell A2. The table then expands to include their data set. The users want to do a lot of sorting, but then return the data set to its original order, so I need to add a Key field. I'd like a key field that auto-populates in column T when the table expands with the data set. The problem is, if I use a function (such as =Row-1 or =Cell Above Value + 1), the values will always stay 1,2,3,+, regardless of the sort, as the formula is tied to the cell's location, rather than the data set. Hence, the field isn't a key field at all.
Does anyone have an idea of how to create this key field that will auto-populate itself but still sort with the data? I'm at a loss!
*No macros, please*