+ Reply to Thread
Results 1 to 3 of 3

Match columns

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    109

    Match columns

    Hello guys I have got following code,

    the code check column A and B in sheet1 then match them with sheet2 A and B,


    Sheet1
    3o7XAu5.png


    Sheet2
    338pTom.png

    if column A and B sheet1 match column a and B in sheet2,
    take the matching cell in this result,
    sheet 1 same row column J the value * the value in column G same row sheet2,

    but if there are cells in sheet1 and column A and B that not exists in Sheet2,

    I get this error

    Runtime error 13 : incompatible types


    Compare_cells.xlsm


    See attached file.

    Could someone help me ?

    Thank you in advance
    Last edited by elmnas; 08-03-2015 at 09:23 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,596

    Re: Need help to modify a code

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Forum Contributor
    Join Date
    02-23-2015
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    109

    Re: Need help to modify a code

    Quote Originally Posted by zbor View Post
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Sorry my mistake

+ 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. Can someone modify code for me.
    By JayeshG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2015, 03:57 PM
  2. [SOLVED] need to modify this code to only use one tab
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2014, 03:40 PM
  3. How to modify VB code?
    By sem in forum Excel General
    Replies: 3
    Last Post: 08-07-2012, 05:29 AM
  4. [SOLVED] Array Formula vs vBa code - How To Modify My Messy Code To One Of Those
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2012, 12:04 AM
  5. I want to modify the code
    By hesham63 in forum Excel General
    Replies: 8
    Last Post: 07-30-2011, 10:36 AM
  6. Help to modify this code
    By rockyw in forum Excel General
    Replies: 1
    Last Post: 12-28-2010, 07:05 AM
  7. Modify code in UDF
    By Biff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-31-2005, 12:05 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