Copy Single Cell Value to Separate Worksheet Based on Value of Another Cell

[lday75]

I have a worksheet that I will be entering tournament registration names on and filling in the events they will participate in. What I want is when column H on worksheet "Qualifier" (data validation yes\no) is set to Yes I want the value from "Qualifier".Column A in the same row to be copy\pasted into the next blank row on Worksheet "MD".

I have tried a few different examples that I found however nothing seems to be getting this correctly. The code below I had entered on the On_Change event of worksheet "Qualifier" however this is not firing upon the changing of column H.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Arkadi]

Are you sure it is not firing? based on the code, if the change is not in column T then nothing will happen, even though the event will fire... change T to H if you want H to trigger the code to execute

Please Login or Register  to view this content.

[lday75]

WoW.....my apologies, I thought I had changed that to H and even had myself convinced I saw H there!!! Sometimes ya just need a different pair of eyes I guess.

thanks so much, works like a champ...with the right column listed...duh!

[Arkadi]

Glad it worked out