I am trying to create a VBA code which copy a cell and paste with three condition:
1- If the cell next to the cell targeted is not duplicate.
2- will continue to paste this data till the certain number exceed.
3- will copy another cell and paste with the two above condition also.
(the picture below explain more:
a) the S columns is the target cell where I want to paste.
b) the red circle is the number of how many each name highlighted in yellow should paste.
c) they should not paste if Duplicate appear in columns AA.
1- If the cell next to the cell targeted is not duplicate.
2- will continue to paste this data till the certain number exceed.
3- will copy another cell and paste with the two above condition also.
(the picture below explain more:
a) the S columns is the target cell where I want to paste.
b) the red circle is the number of how many each name highlighted in yellow should paste.
c) they should not paste if Duplicate appear in columns AA.