I need a macro that would copy all columns and rows from one workbook to another. I would like that macro to be triggered from a push of a button. When pressed, it would automatically transfer all the data. How can I accomplish this via a macro or code?
The image may explain one way to clone Workbook1.xlsx to Workbook2.xlsx in response to a click of a button in a different file: