filtered cells

M

minostrada

hello,

I've got in sheet 1 and 2 a autofilter and I want to copy the filter results
to sheet 3. Is that possible and does anybody know how to do it?

greets,

mark
 
T

tina

Hi
You need to copy visible cells only once filtered required data select edit
goto special select visible cells ok then copy this to sheet 3
Tina
 
T

tina

Hi
I will try to explain clearer
on sheet1 select edit from menu bar choose goto option then click special
button and tick visible cells only box click ok
then right click mouse select copy got sheet3 and paste
you will need to repeat for sheet2
hope this is clearer
Tina
 
Top