+ Reply to Thread
Results 1 to 9 of 9

if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d2, e

  1. #1
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    167

    if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d2, e

    Hi,

    I would like to do the following:

    Column D has 4 categories. When lets say, D1 is written "Matched". I would like the info in K1 to be copied in another sheet.

    When Column D give me the categories "No Match" (Let's say D5 is a no match) I would like the info in G5 to be copied in another sheet.


    Easy enough?...i cant do it ...*cry*

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    Hi,

    adapt the name of the target sheet. The values will be copied into column A:
    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    167

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    macro doesnt work...It doesnt do anything!!!! There is no change recorded

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    Hi,

    I wrote it according to your instructions in post #1, could you please upload a sample workbook?

  5. #5
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    167

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    Book1.xlsmHi,

    I would like to do the following:

    Column D has 2 categories (match and not match). When lets say, D2 is written "Matched". I would like the info in K2 to be copied in result sheet at a specific place but only if the number is not zero. If there is a match and the number in K2 is 0. I would like to copy the number from G2 instead.

    When Column D give me the categories "No Match" (Let's say D5 is a no match) I would like the info in G5 to be copied in result sheet.



    And this, I would like to create a loop that will go trough a list. I put the file in attachBook1.xlsmment

  6. #6
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    167

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    sorry for the confusion..and thanks for the help

  7. #7
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    Hi

    I assume the headings in the Result sheet correspond to the values in column B of the source sheet? if this is true try:
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    167

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    codding send me to error!!

  9. #9
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d

    Hi,

    1. Does the error occur in the sample file from post #5?
    2. What is the error message?
    3. Was there anything copied?

+ 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