Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

merge 2 excel spreadsheet books

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
I need to merge several excel files together and create a master file. I have everything in multiple excel files because it won't all fit in one. I need to merge it all together and find entries that match from file 1 and file 2. Is there a way to merge several spreadsheets together if they are very large? More importantly, I want to find out if there is a way to find entries from file 1 and file 2 and create a database of ONLY those entries that are on file 1 AND file 2. Can I do this without manually sorting?
  • 0





  • Member
  • PipPipPip
  • 272 posts
Hello denileed,

Are all the Workbooks structured the same? (all the columns match, etc?)

When you say they are too large to fit in one file what version of Excel are you using? Prior to Excel 2007, the maximum number of rows per worksheet was 65,000. Does your data exceed that limit?

Are trying to match a certain column or several when you refer to comparing entries between file 1 and file 2?


  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP