If the connecting column is Name then something like:
UPDATE MyTable
SET Comm = (SELECT Fees
FROM MyTable mt2
WHERE mt2.Name = MyTable.Name
AND mt2.Id != MyTable.Id)
However that fails if you have more than 2 rows with the same name so the condition in that case should be expanded.