My vba code to copy row A110 of Mod worksheet to A9 in Table A of Email Data worksheet using some logic like - in Mod worksheet it searches for data i.e. COUNT(DISTINCTM.TRANS_ID) if found then it searches for row selected and it searches for data between the two .