Hi,

Basically, I have clients update a weekly sales data file but I have a master copy that I copy them into each time. I am looking to try and create a macro which copies the selected row from one workbook to another or rather the two current active workbooks so as to not cause an error if the file name the client sends is different each time. Each client is in a different row and so I would need it to copy the row selected rather than a specified row.

Any help would be much appreciated
Thanks