| 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. | ||||||
|
||||||