Hello,

I have a worksheet where I have data entered in a list form, and have other cells in other places in the work book associated with those cells so they "automatically" copied over to those places.
I am using using a filter to collapse and hide empty cells so that the list is in the secondary places is only as long as the entered data. Several lists are stacked on top of each other and are printed out, so I don't want empty cells to show up. Unforunately, having to reapply the filter each time, on each sheet, isn't ideal, and it also doesn't work with a protected sheet.

Is there a better way to do/code this?