Results 1 to 3 of 3

Thread: How to paste data in filtered list of Microsoft Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    61

    How to paste data in filtered list of Microsoft Excel

    I am trying to copy data from an unfiltered list and paste it into a filtered list. I want the data to be pasted into the filtered rows only but they are pasted into the hidden rows as well. Is there a function I can use to get the data pasted into the filtered rows only?

  2. #2
    Join Date
    May 2011
    Posts
    448

    Re: How to paste data in filtered list of Microsoft Excel

    When you paste, the data is pasted in to a contiguous range, even if the sheet is filtered. Perhaps you could use a new column to mark the filtered rows, unfilter, sort on the new column, and paste into the marked rows.

  3. #3
    Join Date
    May 2011
    Posts
    410

    Re: How to paste data in filtered list of Microsoft Excel

    I don't think that there's anything more straight forward for doing it manually. If your cell names: designationmateriel, findesignationmateriel, designationrapport I do not exist either. And in fact what is not working exactly. You know you can also make your copy with a Sheets ("rapportjournalier"). Range ("designationrapport"). Value = Sheets ("monitoring equipment"). Range ("designationmateriel"). Value This possibly in a loop. This will prevent selects

Similar Threads

  1. Replies: 2
    Last Post: 24-02-2012, 07:18 PM
  2. Not able to Paste Data from any source to Excel
    By M.N.S in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:56 PM
  3. Want to paste data only in visible cell of Microsoft Excel
    By FullTimepass in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 07:21 PM
  4. How to paste range of name list in Excel worksheet
    By vALaNCiA in forum Windows Software
    Replies: 3
    Last Post: 11-01-2012, 06:10 PM
  5. I am not able to copy and paste data in Excel 2008
    By Apple.Mac.Rocker in forum Windows Software
    Replies: 3
    Last Post: 07-10-2009, 10:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,598,103.87571 seconds with 17 queries