Results 1 to 2 of 2

add data with matching criteria

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    Kansas
    Posts
    32

    add data with matching criteria

    I am working with two worksheets

    Stock -
    Info -

    I need to match the data in Info(Column4) with the data in Stock(Column1), and copy the corresponding data from Stock(Columns 2-27) on to the matching row of Info(Columns 12-37)

    and do this until Stock(Column1) is blank

    From previous help on this forum, I can do the loop til blank...
    itemInfo = 4 'Info Item # Column
    itemStock = 1 'Stock Item # Column
    currentRow = 1 'Start Row
    done = False
    Do
        'If the data in column itemStock is blank, then stop
        If Cells(currentRow, itemStock) = "" Then
            done = True
        Else
            currentRow = currentRow + 1
        End If
    Loop Until done
    but I'm having trouble with the proper terminology for copying the matching data from one worksheet to the other.

    Any help you can give me would be greatly appreciated
    Last edited by Leith Ross; 10-16-2008 at 12:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Comparing two worksheets and matching data
    By Shaunclippo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2008, 03:04 PM
  2. How do I use lookup to find data based on 3 criteria?
    By jerickson in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-03-2008, 09:26 AM
  3. Matching data between two sheets
    By elad in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-13-2008, 08:33 AM
  4. matching data - vba required?
    By Sparky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2007, 02:54 PM
  5. Matching and highlighting Common Data
    By dj1cincy in forum Excel General
    Replies: 1
    Last Post: 01-07-2007, 05:10 AM

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