I can do this manually using the 'Find All' tool within Excel, selecting the cells using 'Find what:', and then using Ctrl+A to select all the items found, then closing the 'Find All' tool, and using Ctrl+C to copy all the cells, moving on to the next workbook, and then using Ctrl+V to paste these cells. I wanted to select any cells that contain the text 'First name:', and then copy and paste these cells into a column in a different workbook. I have been trying to work out a way of automating a method to select certain data from this column in one workbook, and paste it into a column in a new workbook.įor example, I have a list of names in the column. I have a large set of data contained within single column in an Excel spreadsheet.
