I have a spreadsheet that is constantly being filtered, it
contains our item codes and the vendors associated to
them, along with many columns of information.

My problem which I hope can be eased easily is that whilst
my spreadsheet is filtered, I create a formula within the
filter, but I wish to copy and paste special, values but
it doesnt paste into the filtered cells but into cells
asif it wasnt filtered.

Can this be overcome easily without having to sort by
column H (for instance) then action performed, then
resorted back to Column A?

Thanks to all who offer their advice :)

Jeff