+ Reply to Thread
Results 1 to 5 of 5

compare Sheet2 against Sheet3 with highlighting results in Sheet2

  1. #1
    Registered User
    Join Date
    07-12-2011
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    compare Sheet2 against Sheet3 with highlighting results in Sheet2

    Good day to everyone!

    I believe, there are smart and kind people out there who share their expertise in excel programming or the likes. I have a very manual "litic" job everyday that eats my big time at work. Pls help me hasten and improve my work and performance.

    I find it hard to compare Sheet 2 against Sheet 3, in such a way that what ever input i have in Sheet 3 (only 1 column) will result to being HIGHLIGHTED ( in any color) in Sheet2. But provided that only 8 characters be pasted in Sheet 3.I mean,No matter how long is the partnumber or partname i copied from other workbook or worksheet, if i paste it in Sheet 3 (on the 1 column) "only the first 8 character must be displayed" And this 8 characters that were in Sheet3, if it can be found in Sheet2 from any cell, the cell would be highlighted.

    Then, it would be nice if i have button in Sheet1 to click like named as "compare", in such a way that when i click the "compare"button, the comparison will took place.

    I am so sorry with my English. I try my hardest to make you understand. Hope you could help me solve my problem.

    thank you so much. Have a nice day!

    Mariposa

    btw, i attach sample file. Pls. see.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-27-2011
    Location
    CA, Montreal
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: compare Sheet2 against Sheet3 with highlighting results in Sheet2

    There you go. Its in attachment.
    have fun


    For those who are interested in src n lazy to dl
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-12-2011
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: compare Sheet2 against Sheet3 with highlighting results in Sheet2

    hi xiaoy312,

    i am very thankful for your help. but when i download the excel attachment, the button in the first sheet didnt work (not the blue one i know its just a text box)...please help me. do i miss something that i needed to do to make your excel file work?

    regards,
    mariposa

  4. #4
    Registered User
    Join Date
    07-12-2011
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: compare Sheet2 against Sheet3 with highlighting results in Sheet2

    hi xiaoy312,

    wow...it really work the way i want it...thank you so so much...

    i am really really happy! its now 2:48 in the morning here, and i am still awake figuring out your help..
    now it really work....thank you xiaoy312.
    hope you can help me and others soon when i need help..

    have a nice day,
    mariposa
    mariposa

  5. #5
    Registered User
    Join Date
    07-12-2011
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: compare Sheet2 against Sheet3 with highlighting results in Sheet2

    hi xiaoy312,

    when i tried it in the real work,i copied another masterlist worksheet and paste it in Sheet2;then another worksheet and paste it in Sheet3; but when i run compare--- the program didnt work.
    there is pop up that says: Run-time error'457' This key is already associated with an element of this selection."

    i have attach another worksheet as an example to copy and paste to the excel program you make. Pls. try it, i have problem still with the application. I need your help xiaoy312.
    PLEASE help me to solve my issue.

    thank you so much.

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

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