VBA to Add Column to Table Based on Value in Cell

Hi all,

I am working on creating a table for calculating daily rate and margin for a company. We are currently working with several rates. However, in the near future there is a chance for adding one on two more. Attached is part of the example for the first page. Now I cannot figure out which formula to put to automatically populate the field "column1" when we enter new rate, not listed already. Can it be done without using VBA? I was considering conditional IF function with match for all the previous cells.
Any ideas will be appreciated.

Thank you in advance