Can I keep my place in a table when switching between sheets?
Say I have a data table of 500 customer account numbers. I have added unique row numbers (1-500).
However, say I scroll down to look at customer '250' and then need to navigate to another sheet and come back, the table defaults back to the top i.e. Customer '1'.
Is there a way of locking my place in the table (customer 250)?
The only selection I am making is on a Country filter, so a bookmark doesn't seem applicable.
