Copy data from range"J", paste in Range "E" when value in range "G" changes

[sumit dey]

Hello Everyone,

This is my first thread at Chandoo.

I have a workbook wherein, I want the user to select a value in Column "G" (having a data validation list containing 0,3 and 10) and the value from the column "J" be pasted in Column "E".
Cells in column "J" have a if function to fetch data from somewhere I want that data to be copied and pasted to cells in column 'E" when the user selects input in column "G" having a data validation list

For e.g.,
Data gets pasted here from "J" When data changes here This data gets pasted in "E"
E23 G23 J23
E24 G24 J24
E25 G25 J25
E26 G26 J26

and so on...

I would also require the pasted data in "E23:E100" to remain editable and when the value in "G23:G100" changes again the macro does it's act again.

I have a sample workbook attached for your ref.

Hope you understand my query.

Thanks

 

[vletm]

@sumit dey
Something like this...
Note) You didn't want to 'clear option' for copy-paste
Q) Is there some logic with column-J's formulas?
J1 checks G1 but other J's checks F's => so far ONLY J1 works!