By using option button fetch data to a cell

[fareedexcel]

Dear Experts,

Please help on my below requirements,

- I'm having two booking reference No in my sheet (c5, f5)
- Also I have added 2 radio buttons as option 1 and option 2
- option 1 for c5 and option 2 for f5
- if i select option 1 radio button , the data in the c5 should get captured in I2 (In a new cell) and if option 2, data in f5 to be captured

Sheet attached for your reference

 

[Thangavel]

Here you go!! Please check the code..

 

[fareedexcel]

Here you go!! Please check the code..

Thangavel. Thank you so much. Ungal Uthavikku mikka nandri