Copy paste to another sheet only once when the condition is met

[ecelebi16]

Hello,

I am trying to improve a tracking a sheet that we go in once a while and update the conditions. If the condition is 1 (meaning 100) then we want to paste into the "Wins" sheet for the selected ranges. The code I have works to paste the entire data when the condition is met, but when I click on the button to update, then it updates everything all over again. I would like to have it updated only once and the next available empty row on "Wins" sheet.

I tried two things:
1) this one runs and copies all the data

Please Login or Register  to view this content.

2) This one gives me an error "Wrong number of arguments or invalid property assignment"

Please Login or Register  to view this content.

*********

Can someone help me figure this out ??

Thank you!
ecelebi16

[bulina2k]

What do you want to copy to "WINS", only the last record in "IC Pipeline" or whatever is selected when you click on the button?

[PaulM100]

Try this:

Please Login or Register  to view this content.

[ecelebi16]

Hi bulinak, I have added the attachment. So you see that column D, the probability gets updated when it is a win, meaning 100. So when I hit update it should add the data at the end of the wins tab when there is potential changes. This change is random, but I want that updated data to be at the end of the wins file when there is change.

But coding updates everything every time when I hit update.

Thank you!

[sintek]

What about forum Rules here
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

(or use the # button)

'! No looping required...Use AutoFilter

[ecelebi16]

Hi PaulM100 , thanks for your response. I used your coding and it does the same thing.. When I go back for the second time, it updates the entire list again.. I only need to have it update it once the probability turns to 1. I attached my excel if you want to take a look at it.

Thank you!

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. I have also noted that you ignored sintek's post about this. In the future that can earn warnings. --6StringJazzer

[PaulM100]

Then you don't need a button, you need it to trigger automatically on cell change. Right click on IC pipeline tab - view code and insert the following code:

Please Login or Register  to view this content.