Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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!

Select a single cell as the paste destination (nt)

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

Re: Copy and paste from a filtered column

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

Try using Advanced Filter and "copy to another location"

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

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

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

Don't Copy/Paste...

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

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

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

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

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

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

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

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

Thanks Mark - works GREAT!! (nt)

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.