Help needed for macro to loop through cells instead of manually doing one by one.

Please see attached video a SCREEN-RECORDED.MP4, it shows clearly my struggle.

I have also attached the workbook.

i need help with macro to be modified so that instead of this copy paste into the helper sheet1 and then getting result back to sheet2

i simply run the macro once and it will loop through sheet2 column A and B and then populate the result in C and D.

i tried for two hours, i could not decipher the decipher the code to make it work.

any help is appreciated.

thanks.
EE.xlsm
Screen-Recorded.mp4