How to combine two Excel spreadsheets into one

KCav45

New Member
Joined
Jun 8, 2020
Messages
1
Office Version
2010
Platform
Windows
I have two Excel spreadsheets with information about My Contacts that I would like to combine. Each contact is on one line and the columns have information like address, phone number etc. What should I do to combine the two worksheets.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Larry Haydn

Board Regular
Joined
Jul 18, 2019
Messages
65
If the columns are the same, you can just copy from sheet A and paste into sheet B.
After that, you may want to sort the result by contact name, to see if there are duplicates.
 

rjmdc

Board Regular
Joined
Apr 29, 2020
Messages
242
Office Version
365
Platform
Windows
you can use append in powerquery
 

Watch MrExcel Video

Forum statistics

Threads
1,100,037
Messages
5,472,112
Members
406,804
Latest member
xbinsx

This Week's Hot Topics

Top