Filtered list copy & paste

[Guest]

Hi,

I have filtered (or subtotaled) a list in excel and got the desiered results. I now want to copy and paste only the filtered list (whick is what i see). If I copy and paste the normal way, then all other undisiered list data appears. is it possible to copy paste only what is filtered?

thank you.

 

[Frank Kabel]

Hi
try the follwoing
- select your filtered range
- hit F5 and click 'Special'
- select 'Visible cells only'
- now copy the data and paste it to the new location

-----Original Message-----
Hi,

I have filtered (or subtotaled) a list in excel and got

the desiered results. I now want to copy and paste only
the filtered list (whick is what i see). If I copy and
paste the normal way, then all other undisiered list data
appears. is it possible to copy paste only what is
filtered??

 

[Guest]

thank you!!! you saved the day!

 

[Don Guillett]

If you do this often, you may want a macro such as
selection.specialcells(xlvisible).copy sheets("sheet10").range("a1")


--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi,

I have filtered (or subtotaled) a list in excel and got the desiered

results. I now want to copy and paste only the filtered list (whick is what
i see). If I copy and paste the normal way, then all other undisiered list
data appears. is it possible to copy paste only what is filtered??

 

[Dave Peterson]

You may want to look at Data|pivottable if you're working with subtotals.

You may find that they're easier to create than doing Data|subtotals.