merge excel workbooks

T

teacher

I need BIG help merging workbooks.

I've created several workbooks with lots of formulas. I just need to be able to replace a page on each one. I thought I could make the new page and copy it in, but it makes weird links.

I would like to try merge in tools, but it's 'grayed out' so that you can't activate it.

I need help ASAP!

Thanks!
 
S

Sippo

I can't merge either. The option is greyed out.

How to select two workbooks in memory? May be then merge works!
 
B

Bob Greenblatt

I can't merge either. The option is greyed out.

How to select two workbooks in memory? May be then merge works!
Click to expand...
You'll have to explain in more detail what you are trying to accomplish.
Check out Data Consolidate. Or cut and paste and then sort.
 
Top