将Excel中的数据保存到工作表中以便稍后写入或加载

I have a work book that I am trying to take some inserted data and save it on a new row for new data. But if the first cell of that entered data equals another cell in that same column than i want to over write that previously saved data with the newly entered data.I have a work book that I am trying to take som