If the ID numbers in both files are the same, you can link the two files by using the similar (or common) ID field. One file can contain a list of ID numbers, first names, last names, and positions, and another file can contain a list of ID numbers, addresses, and salaries. ![]() Merging two Excel files allows you to combine related information into a single file.įor more information about creating a mail merge data source in Microsoft Excel, click Microsoft Excel Help on the Help menu, type work with a mail merge data source in the Office Assistant or the Answer Wizard, and then click Search to view the topic. You may want to do this so that you can combine related information into a single file and use it in a Microsoft Word mail merge. This article describes how to use Microsoft Query to merge two Microsoft Excel 2000 files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |