merge excel sheet

hi frinds.,

will you pls tell me how to merge 2 excel sheets folders ?

 

1. Open the ablebits.com “Merge Tables Wizard for Excel”.
2. When the tool opens you will be prompted to “Select the Master Table (First Table):”
Make sure all of your data is highlighted in blue. If not:

• Click the table icon next to the cell range.
• Highlight the data.
• Click “OK”.

3. Click “Next”.
4. In the “Select the Lookup Table (second table):” select the other spreadsheet.
5. Make sure all of your data is highlighted in blue. If not, refer to step 7 for selecting your data.
6. Click “Next”.
7. In this screen, make sure the top boxes (3) are checked:
8. Once you’ve verified the checkboxes at the top are selected, select your unique identifier. Make sure the “Master Table Columns” and “Lookup Table Columns” are the same (This is where renaming the columns with the same name comes in handy).
There may be several columns auto selected by default. Make sure that you only select the columns you intend to use as the unique identifier. I strongly recommend you use as few unique identifiers as possible when you are working with more than one database due to differences in data.
9. Click “Next”.
10. In the 4th screen on the “Merge Tables Wizard” you select the placement of the data. There are a couple of ways you can merge this data in Excel:

 

it work, thanks a lot...

 

i do not know how to do this Please tell me any body.

 

@ sksinghsanjeet it works. i realy need this, my heartly thanx to you frnd.

 

thank you very much. i find it for a long time

 

Thank for this task it work properly actually also i have this problems.

 

@sksinghsanjeet . definitely provided an insightful guides here.

 

Thanks for sharing the info, it helps a lot...

 

Thanks a lot for sharing this useful things....