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

[ajwilltravel]

Hi there, I've never known how to do this - in attached sample file, I need to filter column D on "A". That filtered list then contains formulas in each (yellow) row (linked to next worksheet). But I need to be able to copy paste (the visible yellow cells only) as Values - all of them at same time. I know you can easily copy paste visible cells with just one value, or copy paste visible cells with formulas but can't seem to copy a filtered list of formulas as values. I seem to have to do so one row at a time.. surely not?!

Hope this makes sense!

Thanks

[Glenn Kennedy]

Hopefully you have upgraded from V2202....


=FILTER('Filtered List'!C5:G10,BYROW('Filtered List'!C5:C10,LAMBDA(x,AGGREGATE(3,5,x)))=1)

[TMS]

Maybe use a formula to extract the values required and then copy (the extracted data) and paste special values.

Please Login or Register  to view this content.