Hi Looking for some code that tim 1

[Palmcrest]

Hi
Looking for some code that timestamps for me.
When Percentage in column H = 100 percent
then Column G corresponding rows will show timestamps when 100% was achieved.

I want this to be static and not recalculate when the workbook is opened a day or two later

Cheers

 

[Palmcrest]

Cheers Vic
I will run it this morning and have a go.
Thanks for your help.

 

[SkipVought]

I’m Skip, not Vic, but I’m glad you have a satisfactory solution. Thanks for the littlw purple star. I enjoyed crafting this code.

Usually I try to lead the user to write their own code. But since this was event based and a bit more complex in nature than most problems posted here, I elected to generate a turnkey solution. Hope you don’t fell short-changed.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Palmcrest]

Lol , I was channelling the capitol V after Skip in your name, apologies
And yes thank you for your efforts, I am self taught on VBA so I really appreciate looking at and understanding this code.
Im constantly amazed at what can be done and how people construct code to get it done.

 

[SkipVought]

I like that you've been self taught. Keep at it. You'll get lots of good help here at Tek-Tips. Come back any time. Yes, Excel is an amazingly versatile tool. I find it exciting and recreational to use and create solutions.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]