Is there a way for the following
In the temp attached file is on the Sheet 1 when I enter a random word
in cell C6, It automatically transfers to sheet 2 say in column D6 and the
next word is added BELOW in D7 the next is added to cell D8 below the
previous word and so on.
What I am trying to achieve is when I change the word in sheet 1, C6 lets say, the last word was
" This " was moved to Sheet2 cell D6, the next word is " Now ", it checks what is in D6 so if the new
word is different to the cell D6 , it is moved to Sheet 2 Cell D7, then the next new word checks to
see what the previous cell in this case the word in sheet 2 cell D7, and so on.
Basically I am trying to create a dictionary of the words being used in the sheet.
Many thanks in advance