+ Reply to Thread
Results 1 to 5 of 5

Paste Data Into A Filtered List

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    MN
    Posts
    5

    Paste Data Into A Filtered List

    I have a filtered list in Excel. I have created a column in another sheet with data. Now I want to import that data back into the filtered list. Being that it is filtered the rows are not in order. How do I get the data to paste into the filtered list so that it lines back up again.




    Filtered List Data in other worksheet
    1 <------------------ Test = Cell 1
    5 <------------------ Test1 = Cell 2
    8 <------------------- Test2 = Cell 3

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Can you attach an example workbook?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-17-2008
    Location
    MN
    Posts
    5
    Here is an example.

    Thanks for your effort!
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387
    ajb1131,

    This does work, but I am sure it can be approved upon.

    See the attached workbook "Data Filter AutoFilter copy another sheets cells to SpecialCells xlCellTypeVisible - ajb1131 - SDG.xls".

    Then run the "CopyPasteToFilter" macro.


    Have a great day,
    Stan
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try this code


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1