Copy formulas in a filtered table & paste as values (visible cells only)

Hi there, I am working in a table that I have to filter regularly.

If I want to copy a formula into every visible cell in the filtered list it works fine - I just copy the cell with the formula then select all visible cells in the filtered table, go to 'select visible cells only' and then paste as formulas - no problem.

However, I then need to covert those cells that are formulas to values. If I copy all those same visible cells in the table (cells with the formulas in them) and then go to 'select visible cells only' and paste as values, it doesn't work. I get the error "This action won't work on multiple selections".

Is there are way to do this?

Thanks

Hi again, ok in attached, if I filter column B "Q1 Planned", all the orange highlighted values in columns C & D are formulas.

I want to be able to apply that filter then select all those orange values (down to row 9 - so excluding totals at bottom) and go copy, visible cells only icon then paste as values.

But I get an error "This action won't work on multiple selections."

Thanks...

I couldn't agree with you more! Unfort my boss is not excel savvy at all and he created a worksheet that he likes and I am stuck with it so i have to do all these workarounds to get results he wants. I will add sorting to it though and explain to him why - I'm sure he'll agree to that. Thanks very much!