+ Reply to Thread
Results 1 to 3 of 3

VBA-Comparing 2 Worksheets same Workbook

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question VBA-Comparing 2 Worksheets same Workbook

    I searched for my topic and nothing matched my questions:

    I have 2 worksheets, within one workbook

    sheet1 is a list of EE's who took the test either, failed, passed, or incomplete
    sheet2 is a list of ALL employees who SHOULD HAVE taken the test

    I need to determine:
    Failed, incomplete and who did not show up

    The data is raw and the fields do not match. Meaning one sheet has last name, first name in one field or vice versa. Also some people used their middle initial one one sheet and did not on the other sheet. So I know some manual eyeballing is going to be required.

    I found VBA code that would perform most of the work, however I do not know VBA and the instructions are not basic enough. I know how to open VBA, insert module, copy and paste the code, open macros and run. Literally that's it. I'm missing a whole bunch of stuff in between. Such as:

    1. in the code, where do I tailor the cells and names so the code can read my worksheets and workbook?
    2. am I suppose to open VBA in another worksheet or a new workbook?
    3. I think I read when VBA is run correctly my results will download to a new workbook

    So just giving you an idea of what instructions I need. I am pretty sure I have the right VBA code.

    Thank ya much!

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: VBA-Comparing 2 Worksheets same Workbook

    Welcome to the forum!

    It sounds like it would be easier to help you with your problem if you were able to redact any personal information and post some sample worksheets. Since there is no standard to the ws format it will help us get an idea of where the information is and where it needs to be.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: VBA-Comparing 2 Worksheets same Workbook

    ok thank you. I removed the personal stuff because for my reporting I don't need it.

    I have attached
    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. Comparing Two Worksheets
    By RFJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2005, 11:05 AM
  2. Comparing 2 worksheets
    By Cube Farmer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] Comparing 2 worksheets
    By Cube Farmer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  4. Comparing 2 worksheets
    By Cube Farmer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. comparing worksheets
    By unsworthcl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2005, 04:20 AM

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