Brief: The results of a
filter are not mutable. I cannot directly add/edit rows to the cells in and around a
filter result due to a
#REF Error: not expanded because it would overwrite data error.
I have two tabs of Sheets. I'm referencing a range of columns from Sheet A onto Sheet B by using the
Here are two images illustrating the above statement:
The functionality I'm going for, as shown in Image A/Sheet A, is being able to change the dropdown value in the
Category column to
Bug, and having certain values from that row be transferred over to the Sheet B.
As shown in Image B/Sheet B, I can add columns to the right, due to it not interacting with the filter results.
My problem is in trying to find these two things:
- A way to directly edit the contents of the filter results of Sheet B.
- A way to freely & manually add rows around the filter results, and continuously have filter results be transferred over to this sheet without issue.
Attempting to do 1 or 2 will result in some or all of the data to disappear or a
#REF error to occur.
How can I achieve the desired results with or without