Hi,

Is there anyway you can paste cells into a filtered list so that only the visible cells are pasted on top of?

i am copying from a filtered list using 'visible cells only' but then when i paste into the filtered list on a different excell book it won't let me paste on the visible cells, it copies into the non filtered cells which is kinda annoying,

not sure if this is possible, thanks in advance,

cc