Copy and paste visible cells using grouped rows?

[dpnab]

I have grouped rows which shows a subtotal formula for each group.

I have a 2022 and 2023 column. I want to copy the formula from 2023 into 2022.

This is the formula for 2023:

=SUBTOTAL(9,F41:F58)

This is what the formula changes to when I copy/paste it into 2022:
=SUBTOTAL(9,E41:E58)

Which is what I want. Since they are grouped rows, I can minimize/hide all the data and just view the total rows. Unfortunately I cannot simply copy and pate these cells to carry over the formula, I can only do it 1 by 1 which will take forever.

I tried using go to special but it only works for copying. I can't paste it back.

What options do I have?

Thanks!

 

[dpnab]

bump