Copying and Migrating from one Spreadsheet to another
Posted on 2011-02-21
I have two fairly complex workbooks created in Excel 2010. The function in one, I want in the other and thus I must move/copy or migrate 4 sheets in the source to the target. What considerations should I take into account as I try to bring in the functionality? For example, should I copy or move the functionality (i.e.create a copy of the source and paste it into the other workbook). Will Macros automatically come over when I copy a sheet from source to target? If I have to copy over the macros, do they have to be in the same "Module"? Will Range Names copy over? I'm looking to try to not create a huge problem as I try to bring over the functionality and want to understand any "gotchas".