TO paste data in filtered range..

Hii..

I copied some data from filtered range & tried to paste it into another workbook in filtered column but getting error message "This action not work on multiple selections" though I have selected only the visible areas to paste the data..

If I don't select only the visible cells it paste the data into hidden cells also which I don't want it to do..what is the solution??

Thanks..

When you copy a filtered selection it automaticly breaks up your selection in many sections each range of visible rows between two hidden rows are a separate copy selection

On the paste side you need a blank sheet or at least a unfiltered list as paste area as excel does not now how to paste multiple selection in to multiple area's,

You would have to use a Vlookup formula or an Index and Match formula combination to find the values you want to paste.

Or you must paste your selection below the current data in the sheet you paste to and then sort and refilter

Originally Posted by Vivek2705

Hii..

I copied some data from filtered range & tried to paste it into another workbook in filtered column but getting error message "This action not work on multiple selections" though I have selected only the visible areas to paste the data..

If I don't select only the visible cells it paste the data into hidden cells also which I don't want it to do..what is the solution??

Thanks..

I wrote a vba code to copy paste values from filtered range to another filtered range, but it only works for copy-paste between sheets in the same workbook not to another workbook.
Let me know if you're interested.

Originally Posted by Akuini

I wrote a vba code to copy paste values from filtered range to another filtered range, but it only works for copy-paste between sheets in the same workbook not to another workbook.
Let me know if you're interested.

Yes sure pls tell me..I would love to have the same..

Originally Posted by Roel Jongman

When you copy a filtered selection it automaticly breaks up your selection in many sections each range of visible rows between two hidden rows are a separate copy selection

On the paste side you need a blank sheet or at least a unfiltered list as paste area as excel does not now how to paste multiple selection in to multiple area's,

You would have to use a Vlookup formula or an Index and Match formula combination to find the values you want to paste.

Or you must paste your selection below the current data in the sheet you paste to and then sort and refilter

Ok will try the same..thanks a lot..

Ok, try this:

Please Login or Register  to view this content.