I am trying to create a macro to copy say T25 to T50, paste to S25 the copy K25 to K50 and paste to the next empty cell after the contents of S25 to the last filled cell. I then want to remove any duplicates in S25 to end and sort.
So I have data starting at K25 and T25 but the number of cells...