My first post on here was answered so quickly with a very useful sub so i thought i'd see if anyone can help with another problem im having.
I am trying to do the following:
I am trying to write a sub that will
look at 'Client' column "A" and then search 'Carer' column "A" for the same value. If it finds the same value i want it to copy this value in 'Carer' column "D" (for the row that the searched for value exist on) and paste this into Client column "C" (in the row that the searched for value exists in)
I then need it to repeat this procedure for 'Client' cells 'A3', 'A4' etc until the end is reached.
I found it difficult to explain exactly what i want to do here so if this is not clear to you please ask me to elaborate on any area of my query.