filtered cells
 

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

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
"minostrada" wrote:

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

Hi tina,

I don't exactly know what you meant with your post

"tina" wrote:

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
"minostrada" wrote:

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

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


"minostrada" wrote:

Hi tina,

I don't exactly know what you meant with your post

"tina" wrote:

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
"minostrada" wrote:

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