Question

how do create consolidate data? ​

Answer 1

Answer:

Step 1: Open all files (workbooks) that contain the data you want to consolidate. Step 2: Ensure the data is organized in the same way (see example below). Step 3: On the Data ribbons, select Data Tools and then Consolidate. Step 4: Select the method of consolidation (in our example, it's Sum).

Answer 2

Answer:

hope It helps you

good evening guys..