| Consolidate ranges |  |
With this tool you can consolidate information of precedent ranges from different sheets in only one range.
Use instructions:
|
|||
|
|||
With this tool you can consolidate information of precedent ranges from different sheets in only one range. |
|||
|
|||
| For Example : If you have the following sheets with their respective ranges. | |||
|
|||
|
|||
|
|||
Use instructions: |
|||
| 1.-Select the headboard of ranges from any of the 3 mentioned sheets. | |||
| 2.-Check in the corresponding sheet that you want to implicate in the consolidation. | |||
| 3.-Click on the Do it button. | |||
|
|||
| Finally this is the result. | |||
| The ranges of its 3 sheets have been consolidated in one sheet. | |||
|
|||