Excel Copy Paste as Value in every second Excel VBA code

[Kumar Chandra]

Please help me to write code for below.

I have one "Lists" sheet, I need code for G3:G20 Copy and paste as Value in H3:H20 in every second automatic.

Basically, i have one "Form" sheet and when i change data in "Form" Sheet i want this data to update in "Lists" Sheet.

Thank you,
Hoping to receive this answer.

 

[ravishankar]

you wnat copy and paste every second or only whenever you change form sheet?
ravishankar