How to combine Excel files in one

Often when working in a tabular editor occurs in such a way that the necessary information is located on separate work sheets or files. Before users, the task of combining multiple sheets and files to a single integer. You can, of course, by copying the cells from one document and insert them into another file to implement the combination procedure, but it is inconvenient and inefficient. In the article, we will consider in detail several effective methods that allow you to implement combining table documents into one.

Combining workers in one in the table editor

Initially, consider such a procedure as combining workers in one document. Detailed instructions look like this:

1. We produce opening of the working sheets that we plan to merge into one file.
2. Moving in the subsection having the name "Home". Here in the format command block, we find an element under the name "Move or copy a sheet" and click on it with left mouse button.
3. In the open list, click the left key of the mouse to the "(new book) button".
4. After the implementation of all actions, we click on "OK".
5. Similar operations must be made with the other sheets of a tabular document.

Union of information in one file

Often there are such situations when it is necessary to combine some of the information fragments into a single file. This procedure is performed quite easily using the table editor tools. The most important thing is the information located in the signs must be formatted in advance so that in the future it is not to spend a huge amount of time to bring the overall sign to normal appearance. Detailed instructions look like this:

1. For example, we have the following data that must be transferred to one file. The process of the association will correctly work only under the observance of several certain points. Working leaves that will undergo consolidation procedure should be given to uniform formatting with identical headlines and information formats. Everything else, the combined information should not contain empty lines and columns.

one

1. After we bring the information from different work areas to uniform formatting, we need to implement the creation of a new working sheet. You can do this by pressing the left mouse button on a small plusion of a dark color, located at the bottom of the table editor interface next to the tabs of other sheets.

1. At the next stage, we move to a section that has the name "Data". It is possible to find it from above, in the main menu of the table editor. Here we find an element named "Consolidation", and click on it with left mouse button.

2.

1. In the applied list, click the left key of the mouse over the elements "amount". Next, we enter the coordinates of the cells that we plan to combine.

3.

1. Similar actions we produce with other information that we plan to combine into one file.
2. After all the necessary actions, we click on "OK" to confirm the changes made.

four

Combining files with VBA

Macros, prescribed in VBA, are excellent to implement the procedure for combining multiple tabular documents into a single file. The procedure is not so complicated, as it seems at first glance. The main thing is to follow the items of detailed instructions:

1. Initially, you must make sure that all the necessary tabular documents are located in one place of the personal computer.
2. At the next stage, it is necessary to go to the Eksel's tabular editor and create a new book in it, which will serve as a tool for combining other tabular documents.
3. Using a special combination of hot keys "Alt + F11", we move to Visual Basic.

five

1. First, click on "Paste", and then in the list that appears, click the left key of the mouse to the element having the name "Module".
2. Now you need to write next small code here:

1. In the PATH variable it is necessary to write the path to the place of the personal computer, which contains table documents for the merger.
2. We produce Saving a tabular document in "XLSM" format to activate the created macros.
3. We make the launch of the macro.
4. Ready! We combined all the files in the folder in one tabular document.

Conclusion

We found out that there are many ways to implement a merging of multiple files into one tabular document. Use a function called "Consolidation" is appropriate only if the files contain only the number information, since the function is not capable of working with text format data correctly. The most effective way to qualitatively combine the tabular documents in one file without losing information is the use of an integrated programming language "Visual Basic" and activation of special macros. However, each user will be able to choose a more convenient way to combine table documents.

Message How to merge Excel files to one appeared first to information technology.