Copy and paste in filtered sheet

Hello!

I have a heavily filtered excel sheet with hidden rows that I do a Vlookup in to update inventory. I want to replace the formula with just value. When I go to copy and paste it won’t allow it due to the hidden cells. I’ve tried find&select visible cells and many other shortcuts but nothing has worked besides manually copying and pasting each small set of rows. Does anyone have a trick?