Hi All--

I have a Worksheet_Change event that occurs whenever a new value is added in column A of Sheet 1, it copies down formulas from the row above in columns B:AB and also creates a corresponding new row in Sheet 2. It works perfectly except when filtering is turned on.

The issue is that when data is filtered (column R), Sheet 1 events work as they should, but the new row is not added in Sheet 2.

I'd prefer not to have to deal with unfiltering and refiltering at all in the process, but I added an unfilter/refilter line to the macro as well, but it doesn't fix the problem (nor seem to actually affect the filtering at all). Relevant details regarding the filter follows below the code.

Worksheet code:
Please Login or Register  to view this content.
Facts about the filter:
  • Only the spreadsheet owner uses filtering to display rows that have blanks in column R (with a toggle button I created so that Sheets 1 & 2 are filtered the same).
  • Newly added rows will have a blank in column R by default, so it would be visible with or without filtering turned on.
  • The department that enters the new column A data does not have permission to use the filter (nor would they remember to do so).

Any ideas or suggestions would be greatly appreciated.