Hi
Using a macro, I need to copy column A from a sheet in another book in the same folder as my current book and paste to column A. I would like not to have to open the book to do this. I assume that the book name and sheet name would have to always be the same; such as Book1, Sheet1. I would then create a button to assign the macro to.
TIA!
Using a macro, I need to copy column A from a sheet in another book in the same folder as my current book and paste to column A. I would like not to have to open the book to do this. I assume that the book name and sheet name would have to always be the same; such as Book1, Sheet1. I would then create a button to assign the macro to.
TIA!