Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want to paste data only in visible cell of Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-02-2012
Member
 
Join Date: Oct 2011
Posts: 96
Want to paste data only in visible cell of Microsoft Excel

I need to put data into a spreadsheet built and maintained by someone else for a variety of uses. The rows I care about are not consecutive, but appear consecutive when the file is filtered. I compile my data in another spreadsheet and want to copy-and-paste into the first spreadsheet. To avoid having to tediously copy each row individually, I would like to be able to copy the entire data set from my own spreadsheet and then paste it into the first spreadsheet in a single operation. Is there a way to paste so that the values go only into the visible cells.

Reply With Quote
  #2  
Old 16-02-2012
Member
 
Join Date: Nov 2010
Posts: 502
Re: Want to paste data only in visible cell of Microsoft Excel

Indeed xls will copy also hidden rows. Rather then writing difficult macro's that detect the rowheight = 0 for every cell, why don't you sort you data on the column that you use to filter. In that way all data that appears consecutive in the filter actually is consecutive - which enables easy copying.
Reply With Quote
  #3  
Old 16-02-2012
Member
 
Join Date: Nov 2010
Posts: 420
Re: Want to paste data only in visible cell of Microsoft Excel

Apparently this manipulation cannot be possible just by copy pate. We must create a new column and index to allow cells to recover the result of the filter and then copy the cells with the sort. Do the same sort of cells and copy recipients. A basic function not directly available.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Want to paste data only in visible cell of Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to paste Word Table Cell along with paragraph markers in Microsoft Excel Mayuus MS Office Support 2 17-02-2012 07:09 PM
How to paste content only in the visible cell of Microsoft Excel Talisha MS Office Support 2 03-02-2012 06:28 PM
Not able to address vba in the first visible cell in a Column after filtering in Excel SirName MS Office Support 1 25-01-2012 05:27 PM
How to paste data in filtered list of Microsoft Excel SeanZ MS Office Support 2 24-01-2012 12:00 PM
Copy Text from One Cell to Another in Microsoft Excel without copy & paste Computer_Freak Tips & Tweaks 0 18-03-2009 10:00 PM


All times are GMT +5.5. The time now is 04:41 AM.