MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy and paste from a filtered column


Posted by Chrisb on November 08, 2001 1:14 PM

I am trying to copy data from one column to another using a filter to select the data. I can copy, and paste, but when I try to paste special values, I get the message that "The information cannot be copied because the Copy area and the paste area are not the same size and shape" Is there a way to do this?

Thanks!


Posted by Mark W. on November 08, 2001 1:18 PM

Select a single cell as the paste destination (nt)

Posted by Randy B on November 08, 2001 1:20 PM


Try using Advanced Filter and "copy to another location"

Posted by Chrisb on November 08, 2001 2:10 PM

Advanced filter doesn't seem to allow me to paste?


The location I want to copy to already has data - I want to overwrite this data and can't figure out how to do it.

Example:
I filter on a code in Column D, and want to copy (or cut) the qty in Column B and paste it into Column C - which originally has a qty of "0"

A B C D
1 cat 245 0 AN
7 lion 333 0 AN
12 bear 385 0 AN
22 bee 22 0 AN

Thanks!

Chris

Posted by Mark W. on November 08, 2001 2:35 PM

Don't Copy/Paste...

...instead, type =B:B in the 1st displayed column C
cell and copy down.

Posted by Chrisb on November 08, 2001 4:50 PM

Re: Don't Copy/Paste... Thanks, works but.....

Thanks Mark - it worked beautifully - but I omitted mentioning that I then need to delete the data from the row I copied from, thus deleting my reference (sorry) - any suggestion? ...instead, type =B:B in the 1st displayed column C

Posted by Mark W. on November 09, 2001 6:17 AM

Re: Don't Copy/Paste... Thanks, works but.....

Unfilter and then Copy/Paste Special Values on
column C. Thanks Mark - it worked beautifully - but I omitted mentioning that I then need to delete the data from the row I copied from, thus deleting my reference (sorry) - any suggestion? : ...instead, type =B:B in the 1st displayed column C

Posted by Chrisb on November 09, 2001 8:41 AM

Thanks Mark - works GREAT!! (nt)