Target Multiple Rows

[Darren_Murphy]

There is a technique that uses a bit of smoke and mirrors to give the illusion of changing values in multiple rows - without actually changing them.

I don’t know if that would make sense for your use case, but perhaps have a read of the following:

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

The example that Jeff showcases is used to “reset” values in multiple rows, but the same technique can be adapted to “change” values.