**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to merge 2 worksheets into 1 and tie together a common column

Solved by S. A. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
11/08/2017 - 08:58

I have the files but cannot upload them, just need someone to guide me through what to do

User
11/08/2017 - 08:58

confidential data

Excelchat Expert
11/08/2017 - 08:59

Okay, I understand

Excelchat Expert
11/08/2017 - 08:59

Now, will I just share you a step by step procedure in merging your file?

User
11/08/2017 - 09:00

perfect as long as it include the Common Field...both fields have a Policy Number field and there are common numbers in there that need to line up

Excelchat Expert
11/08/2017 - 09:01

well, have you added a "Kutols" on your excel spreadsheet?

User
11/08/2017 - 09:01

yes

Excelchat Expert
11/08/2017 - 09:01

great,

Excelchat Expert
11/08/2017 - 09:02

Now we can continue into the explanation step of this session. I am going to perform the following: a step by step procedure on how to to merge 2 worksheets into 1 and tie together a common column

User
11/08/2017 - 09:02

lets do it - thx

Excelchat Expert
11/08/2017 - 09:03

First, under your "Enterprise " tab, please click "Combine" found at the toolbar

User
11/08/2017 - 09:04

ok

Excelchat Expert
11/08/2017 - 09:04

Okay, can you see a a dialog pops out to remind you the opened workbook cannot be combine?

User
11/08/2017 - 09:05

no - what does that mean

Excelchat Expert
11/08/2017 - 09:06

means, it will let you open the workbook, it did not pop up, maybe because your worksheet are now open

Excelchat Expert
11/08/2017 - 09:06

So, let's go on

User
11/08/2017 - 09:06

yes they are open

Excelchat Expert
11/08/2017 - 09:06

any dialog box that pops reminding you to save file, just click OK

User
11/08/2017 - 09:07

ok

Excelchat Expert
11/08/2017 - 09:07

then in the Combine Worksheets wizard, select Combine multiple worksheets from workbooks into one worksheet option

User
11/08/2017 - 09:08

under enterprise - combine?

Excelchat Expert
11/08/2017 - 09:08

worksheets are listed in the list boxes showing at your boxe

Excelchat Expert
11/08/2017 - 09:09

Combine worksheets

Excelchat Expert
11/08/2017 - 09:10

have you seen it now

User
11/08/2017 - 09:10

excel crashed

Excelchat Expert
11/08/2017 - 09:11

next is just Combine multiple worksheets from workbooks into one worksheet option

User
11/08/2017 - 09:11

Kutools wants working

User
11/08/2017 - 09:11

now it is

Excelchat Expert
11/08/2017 - 09:11

owss, smehow

Excelchat Expert
11/08/2017 - 09:11

confusing too

Excelchat Expert
11/08/2017 - 09:12

at the 3rd step, just click Combine multiple worksheets from workbooks into one worksheet option

Excelchat Expert
11/08/2017 - 09:12

then click "Next" button

User
11/08/2017 - 09:12

how do i find worksheet 2?

Excelchat Expert
11/08/2017 - 09:13

all the opened workbooks and worksheets are listed in the list boxes upon click "Next" button

Excelchat Expert
11/08/2017 - 09:13

you can check the worksheets in there to merge on

User
11/08/2017 - 09:14

how do I find common field? policy number?

Excelchat Expert
11/08/2017 - 09:14

There's also an arrow sign there to click for you to select the ranges of cell to merge on in a certain worksheets

Excelchat Expert
11/08/2017 - 09:15

hope you can see the arrow diagonal in red color

User
11/08/2017 - 09:16

yes I do for one sheet - it is done but what about the other sheet

Excelchat Expert
11/08/2017 - 09:16

click on it to let you choose the ranges of cell just like your primary keys

Excelchat Expert
11/08/2017 - 09:16

click OK

User
11/08/2017 - 09:16

ok

Excelchat Expert
11/08/2017 - 09:16

then click again to anoher worksheet

Excelchat Expert
11/08/2017 - 09:16

for you to transfer worksheet from one another

Excelchat Expert
11/08/2017 - 09:17

you may also click Add button to insert the files you want to combine.

User
11/08/2017 - 09:17

i see both sheets on Workbook list but not on Worksheet list

Excelchat Expert
11/08/2017 - 09:17

I think that's your present worksheet now

User
11/08/2017 - 09:17

so hit finish?

Excelchat Expert
11/08/2017 - 09:17

click beside it the boxes

Excelchat Expert
11/08/2017 - 09:18

sure

Excelchat Expert
11/08/2017 - 09:18

n done

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*