Results 1 to 3 of 3

Thread: Want to paste data only in visible cell of Microsoft Excel

  1. #1
    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.

  2. #2
    Join Date
    Nov 2010
    Posts
    505

    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.

  3. #3
    Join Date
    Nov 2010
    Posts
    423

    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.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 07:09 PM
  2. Replies: 2
    Last Post: 03-02-2012, 06:28 PM
  3. Replies: 1
    Last Post: 25-01-2012, 05:27 PM
  4. How to paste data in filtered list of Microsoft Excel
    By SeanZ in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 12:00 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •