Hello Everyone,

Just curious if there is a way to copy from any open workbook to a new workbook? In other words...I'd like to have the ability to open any workbook of choice and run a macro from my personal quick access toolbar that copies data and paste values into another workbook without having to write the code to a specific workbook each time. Any ideas?

I have the code written to open a new workbook and save with a new name, but I'm stumped on the copy/paste portion of the code. Any help would be appreciated.

Thank you in advance!