Filterred mode copy and paste area not same

A

aligahk06

Active Member
Joined
Apr 26, 2009
Messages
257
Dear All,

I am in filtered mode and a column cells contains formulae.
while remain in filtered mode and copying all those filtered cell contains formulae and pasting
as value the following error encountered.
The information can not be pasted becoz copying area and paste area not the same size and shape.
Try one of the following:

click on a single celland then paste.
Its to difficult to copy each cell and pasting as value becoz no of cell is more than thousands.

Please can i have any option to overcome this problem ?????


Please assist ?

Rgds,

Aligahk06
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
still problem persist.
Dear All,

i mean copying thousand filtered cell ( i.e filtered cell is n12,n14,n19,.......and so on )
that contains formulae and then pasting as value return following error.
Copy and paste area cant overlap unless they are the same size and shape.

and many more.

Please assist ?
 
Upvote 0
I can reproduce your problem if the top left cell of the paste area is within the AutoFilter range. That's not possible.

Why can't you turn off AutoFilter and convert the formulas to values?
 
Upvote 0
Actually i am fetching value from formula based on filter . if i will turn off auto filter then i can not fetch the value from formula.
So Auto filter is important for fetching the data.once data will fetched then i will
convert it into value .

Please assist ?
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Copy paste Special values when some rows are hidden
Replies
3
Views
712
Akuini
Akuini
E
  • Question
Filtering, copying and pasting
Replies
7
Views
378
Exceliscool123456789
E
H
  • Solved
Copy and paste each Sheet as paste special values and retaining same format
Replies
5
Views
438
howard
H
VinceF
  • Solved
VBA to Copy paste value based on value in cell
Replies
4
Views
303
VinceF
VinceF
E
  • Question
Filtering, copying and pasting specific values in different tabs in same spread
Replies
1
Views
357
Exceliscool123456789
E

Forum statistics

Threads
1,214,661
Messages
6,120,792
Members
448,994
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top