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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Start a mail merge upon opening the document 1
Page numbering with Merged Document and IF statements 1
Booklet in Word, Merge Directory from Excel 0
Need help merging Excel into Publisher Booklet w 2 columns 0
ASK Field Formatting 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Grouping Names in Mail Merge 0

Top