+ Reply to Thread
Results 1 to 5 of 5

Copy values same row/different columns when condition in another column/same row met

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    8

    Copy values same row/different columns when condition in another column/same row met

    Hi, I'm trying to copy/paste values from different columns of the same row when the value in the same row some columns after is met. I'm having problems doing that. Better explained:

    I've a range that goes from AS11 to BO80 and in every row I have in column BP the condition that has to be met. That means, when the value 1 is set automatically in a row, the code has to be trigger by itself and ask if you want to generate an unique code for the activites contained in the mentioned row.

    When the user click on yes, it has to copy just the row where the condition is met and paste it a a value in another sheet ("ActivityCodes") in vertical mode and not horizontal. Another plus wil be if along the copied rows, the name of the user and the date is pasted in every single row where the value is copied.

    A nice to have thing will be that just the columns with values are copied and no empty row in between exist in the sheet ("ActivityCodes").

    Also, the other issue is, in this Sheet ("ActivityCodes") there will be copied values of different input sheets.

    Do you think you could help me????

    Cheers,
    Daniel

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    12-04-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Copy values same row/different columns when condition in another column/same row met

    do you guys have any idea?

  3. #3
    Registered User
    Join Date
    12-04-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Copy values same row/different columns when condition in another column/same row met

    ...any idea?

  4. #4
    Registered User
    Join Date
    12-04-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Copy values same row/different columns when condition in another column/same row met

    after more than 60 views, does anybody has an idea? is it too difficult? please, could anybody help?

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,347

    Re: Copy values same row/different columns when condition in another column/same row met

    maybe something like this
    Please Login or Register  to view this content.

+ 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