+ Reply to Thread
Results 1 to 5 of 5

Mapping the TEXT, Using MACRO

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    43

    Mapping the TEXT, Using MACRO

    Hi,

    Could you please help me, I am facing an issue with mapping the Text, I need to map the text from one to another sheet. When its check the first value, mapping is done after could not able to check the second value.
    I am getting error message is "Object value or with block variable not set"

    I attached the excel sheet, please run the macro,
    First Tab have Column A,B,C, If Column A and B is matched with Second tab content, Column C value should replace to second tab.
    Attached Files Attached Files

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Mapping the TEXT, Using MACRO

    please run the macro
    Total 6 Module.. do you have specific macro has problem, or we need to search all macro, and then guess the error macro, and then ask you for "is this"!!
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Mapping the TEXT, Using MACRO

    Hi Debraj,

    Specific Macro only the problem, If attached the macro, please check this file.

    Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-01-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Mapping the TEXT, Using MACRO

    This Macros are running like,

    In 1st sheet, Column A and B is Matched with 2nd Sheet Content, 1st sheet Column C Value should be replace to the 2nd Sheet.

    Here the problem is 1st data is replace but 2nd data is not able to find in 1st sheet. So i stuck with this issue.

  5. #5
    Registered User
    Join Date
    07-01-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Mapping the TEXT, Using MACRO

    Please resolve this issue

+ 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. To create defect mapping in macro
    By nesh91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2013, 03:11 AM
  2. Macro for mapping
    By louisjeorge75 in forum Excel General
    Replies: 11
    Last Post: 12-16-2011, 02:03 PM
  3. [SOLVED] Look up value according to Mapping and Sum up values macro
    By Eddie in forum Excel General
    Replies: 0
    Last Post: 07-02-2006, 11:50 AM
  4. mapping add-in
    By colettey29 in forum Excel General
    Replies: 7
    Last Post: 06-14-2006, 05:40 AM
  5. Macro to copy columns from 1st sheet to 2nd according to mapping-p
    By Pawan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2005, 01:05 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