+ Reply to Thread
Results 1 to 1 of 1

Using variables to find data on different sheet and writing row with matching criteria

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    16

    Using variables to find data on different sheet and writing row with matching criteria

    Hi all, it has been a long time since I last posted. I have been lurking and learning but obviously I have not learned enough and hoping someone can help me with my problem.

    I don't think it is too complex but I have been trying different things including dusting off my old rusty VBA skills (which failed miserably).

    Anyways....

    I am trying to find data that match my criteria and write out to a new sheet those rows that match. My input file can be 100 rows or 20K rows it all depends on the situation

    1st page is input variables. There will always be 5 variables with one being a range from 1 to x
    2nd page is the details I want to sort through. The column count will always be the same and in the same order. Just the number of rows will change.
    3rd page will be my output where all matching rows are written.

    Any help or guidance will be greatly appreciated.

    Thx - Doug
    Attached Files Attached Files

+ 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