+ Reply to Thread
Results 1 to 2 of 2

Trying to filter data and display it on another sheet, however the data isn't fully copied

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Aalsmeer
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trying to filter data and display it on another sheet, however the data isn't fully copied

    Hi, im trying to filter some data(sheet="Imported Data)" and paste the data that matches to a sheet("Test"). However somehow it doesn't fully work.
    What I want:
    - There are 3 single cells which the user can fill in which are the criteria(Collection , System and Tag)
    - Collection is a MUST fill in for the user, the others can be left blank if the user wants it so. The result must be the entire row(Column A,B and C)
    - If one, two or three criteria are filled in the chosen criterias must all match to copy to the new sheet (so if one criteria is left blank, the result should be all all three criteria. But the one not filled in can be any value).
    - If all criteria match, from the sheet="Imported Data" also the value of column E must be copied to sheet("Test"),
    this value of column E must be the cell which is in the same row as the matched values.
    If you have any questions, fill free to ask... it's a bit hard to explain.
    Thanks for the help in advance! This is what I have now:

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    10-11-2013
    Location
    Aalsmeer
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to filter data and display it on another sheet, however the data isn't fully co

    Anyone got tips or help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data to be copied from one sheet to another sheet by Find option
    By mohandeck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 12:34 AM
  2. Filter data based on columns, display unique row data
    By djarcadian in forum Excel General
    Replies: 14
    Last Post: 05-18-2013, 07:18 PM
  3. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM
  4. Replies: 3
    Last Post: 08-24-2012, 12:24 PM
  5. advanced filter - data not being copied across
    By scubadiver007 in forum Excel General
    Replies: 10
    Last Post: 01-04-2012, 01:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1