Hello All, you have been so hopeful in the past and I need to pick your brain on this. I have a workbook with 10 worksheets. They are labeled "1-10". I am wanting to copy Columns "A:H", beginning with Column A, row 2, since there are headers, and paste unique characters these into sheet11 "Clients", beginning with Column R, row 2. Also if possible, to clear the previous data pasted, and retrieve new data once sheet11 is activated? Thanks in advance, MS