Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |