how do i combine two separate spreadsheets?

G

Guest

I tried the office assistant and it said to go to the tools menu, click
Compare and Merge Workbooks and on my excel program the tools option doesn't
have anything to click on that says compare and merge workbooks? Am I not
understanding. I just want to take one spreadsheet named one way and merge
it into another spreadsheet that's saved under a different name. Some of the
cells on each spreadsheet have the same contents, but I'm not worried about
that. I just want to merge them.
 
G

Guest

Do you just want the data from the 1st worksheet put into the 2nd? Could you
just 'copy' all of your data from sheet 1 then 'paste' it into the 2nd sheet?
 

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

I want to combine 2 workbook data bases and remove duplicates 1
Combine data that spans two rows, preserving cells? 1
Trying to Merge 2 Workbooks 2
How do I match and append/merge data from two spreadsheets? 2
How do I do a "mail merge" from excel to excel? 1
Why doesn't compare and merge work in excel? 2
excel show merge workbooks button 2
merging two large spreadsheets 2

Top