Hi,
I am currently using the following code obtained from here to copy a target row from one workbook to another. The sheet I am copying from has coloured cells, conditional formatting and 2 objects (buttons) on each row. The code works just fine, but I would like to know if it would be possible to modify it so that it only copies specific cells on the row instead of the whole row and removes the formatting so that all it copies across are the cell values.
The code I am currently using is as follows.
Thanks in advance
Bookmarks