I am creating quote base. It would be helpful for me to get auto suggestion of list of words if I type the same thing in the cell that’s been rooted in the same column. So that I can I avoid duplications. Is there anyway to do this? Thank you so much...

Hello everyone, I would like the number in corresponding cell to automatically increase when I clicked copy or cmd + C in certain cell. Is there anyway to do this? Thank you so much in advance for your help!