I have a worksheet with 2 columns of data that has an Auto Filter applied to both columns for filtering purposes.
Directly adjacent to the right hand most column is summary data and a work log of recent activity.
What happens is when the data is filtered, if there are records/cells at the bottom of the list (way past the end of the summary data) that is included in the filtered data, the Summary Data and Work Log disappears until the data is unfiltered.
How do I lock down the data within cells to the right of the 2 columns so that it stays put when the data is filtered?
Directly adjacent to the right hand most column is summary data and a work log of recent activity.
What happens is when the data is filtered, if there are records/cells at the bottom of the list (way past the end of the summary data) that is included in the filtered data, the Summary Data and Work Log disappears until the data is unfiltered.
How do I lock down the data within cells to the right of the 2 columns so that it stays put when the data is filtered?