As above, i.e. assuming that Column A has your company names, column B the amounts then somewhere else in the Worksheet list all your suppliers. You could copy Col A and then do a "Remove Duplicates" leaving you a list where each supplier is listed only once, this avoids typing each one in. Lets...