+ Reply to Thread
Results 1 to 2 of 2

Make only one loop and change compare string

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Make only one loop and change compare string

    Hello,

    I need some help please... Attached find a small example of my code...
    Run them with the order
    first
    second
    third

    you see that I compare if From Sheet the element of Range A is in Sheet1 in Range A then I copy some columns...
    I need to correct two things...

    1. Don't want to do 3 loops for it... how can I make just one and copy all values to the correct columns ?
    2. When comparing I want to add "_" in front of the values of the Sheet2. So for example... I will not look for "Something_AA_A" but for "_Something_AA_A"

    I think this should be easy for you Guru guys

    Thank you in advance...
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Make only one loop and change compare string

    Ok, I managed to fix some things... so now I do only once compare ... and added the "_" in the compare action...

    But I can copy -> paste only two columns... in the third one I get error...

    see in the attached doc...

    if I change this line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    I get the error...

    Please Help
    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