Hello Excel community.

Help please!

I am currently using FILTER to list a certain data field onto a second excel sheet.

On the subsequent rows on the second excel sheet I am inputting information, but when the FILTER data changes, it can affect the list but doesn’t move the rest of the row with it?

how can I adjust the formula or format to allow the row to stick with the filtered information regardless of whether it moves up and down the rows itself?

thanks in advance!

​Hello Excel community.Help please!I am currently using FILTER to list a certain data field onto a second excel sheet.On the subsequent rows on the second excel sheet I am inputting information, but when the FILTER data changes, it can affect the list but doesn’t move the rest of the row with it?how can I adjust the formula or format to allow the row to stick with the filtered information regardless of whether it moves up and down the rows itself?thanks in advance!  Read More

​