+ Reply to Thread
Results 1 to 5 of 5

Match second sheet column "F" with First sheet column "M" & copy column "C" value

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post Match second sheet column "F" with First sheet column "M" & copy column "C" value

    Here i have attached sample sheet.my sample sheet has two modules & it's work fine.i want to modify that codes & need to add another condition to it..
    If i enter values to second sheet column "F" ,it's matching with first sheet column "M" & coping column "d,h,f,g,i" values to second sheet column "a,b,c,d,e".pls add below values to second sheet column "F" (day) & see how it's work..

    163314
    163315
    163316
    163317

    my requirement is after entering values to second sheet column "F" first sheet column "C"(customer) value also i need to copy to second sheet column "H"(customer) like others.pls help me to modify my codes.thanks in advance..
    Attached Files Attached Files
    Last edited by johncena; 04-09-2012 at 11:44 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Match second sheet column "F" with First sheet column "M" & copy column "C" value

    Try the attached file
    Attached Files Attached Files
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  3. #3
    Forum Contributor PingPing's Avatar
    Join Date
    02-19-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    158

    Re: Match second sheet column "F" with First sheet column "M" & copy column "C" value

    Kelshaer beat me to it, but I would have put the 'Application.EnableEvents = {false/true}' stuff around the call to Module1.MoveData in the Worksheet_Change event handler, to make sure no compound events could arise in the future, if you later decided to change MoveData.

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Match second sheet column "F" with First sheet column "M" & copy column "C" value

    PingPing: Thank you for the advice. I modified it accordingly.
    johncena: Use this file instead
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Re: Match second sheet column "F" with First sheet column "M" & copy column "C" value

    thanks a lot for u both.it's work & given REP+ for u both.

+ 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