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.

do you guys have any idea?

...any idea?

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

maybe something like this

Please Login or Register  to view this content.