+ 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)

Similar Threads

  1. Matching multiple criteria from Sheet1 in Sheet2 and writing it in Sheet3
    By smgjob in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2015, 06:16 PM
  2. [SOLVED] Matching multiple criteria from Sheet1 in Sheet2 and writing it in Sheet3
    By smgjob in forum Tips and Tutorials
    Replies: 4
    Last Post: 07-08-2015, 04:10 AM
  3. Replies: 5
    Last Post: 12-14-2013, 01:18 AM
  4. formulas to record data on a different sheet with matching criteria
    By MegaRon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2013, 11:52 AM
  5. Copy Paste data with matching criteria from different sheet
    By Noor Hussain in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 01:23 AM
  6. Matching data between sheet based on criteria
    By elad in forum Excel General
    Replies: 3
    Last Post: 08-14-2009, 03:19 AM
  7. Find matching data in another workbook or sheet
    By Mark R Penn in forum Excel General
    Replies: 4
    Last Post: 02-13-2006, 04:40 PM

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