copy a row and paste the row into another sheet more then one time:macro
Hi Team,
I would like to copy a row when column "C" have some specific value and paste the whole row into another sheet three time. Every times when I paste the rows it should paste at the end of the last row and update the total last rows as well. And when column "C" does not match with the value then paste the row onto another sheet just one time.
Please advice,
Regards,
|