Copying and Migrating from one Spreadsheet to another

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".

Thank you,

B.
Bright01Asked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
How about if I right click on the tab and make a copy or move function?

I was exactly talking about that. Do not do a normal copy and paste.

Sid
0
 
SiddharthRoutCommented:
1) If the code is stored in the sheet code area then you can copy the sheets directly and the code will be copied.

2) If the code is stored in a module then simply right click on the module of the source workbook and export it as a .BAS file which you can import in the new file. Please see snapshot.

Sid
Untitled.jpg
0
 
Bright01Author Commented:
Sid,  Thanks for the reply; what about range names and conditional formatting?  Does that come over with a copy and paste?  How about if I right click on the tab and make a copy or move function?

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.