Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to combine excell 2 files

Status
Not open for further replies.
nowb2509

nowb2509

Technical User
Oct 10, 2006
34
US
Hi
How do you combine 2 excel files into one on to different work sheets

thanks
 
Sort by date Sort by votes



Hi,

How do you want to "combine" these workbooks?

1. copy each sheet to a separate sheet in the new workbook

or

2. copy the data in each sheet into the same columns on the same sheet in the new workbook. This assumes that the columns in each sheet in the original workbooks have similar types of data.

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
1K
remeng
remeng
Andrzejek
  • Locked
  • Question
Word - Combine files
Replies
13
Views
169
Andrzejek
Andrzejek
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Add characters to a cell Excell 1
Replies
4
Views
140
Cpreston
Cpreston
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
431
teknance
teknance

Part and Inventory Search

Sponsor

Back
Top