I have 2 workbooks that I want to merge into one. The problem is that I have macros in both workbooks and I want the macros to be pasted into the new consolidated workbook. Can this be done easily? If so, how? Thanks.