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.