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.