What do you do when you need break out a master spreadsheet into several similar, yet distinct files? If you only need to break the file into a few spreadsheets, then it is not unreasonable to do so manually. It may take a while, but doing so a couple of times won't each up too much time.
However, what if you have 10, 20 or even 200 spreadsheets you want to break out from a master sheet? At this point your options would appear to be:
- spend endless hours to manually copy and paste spreadsheets together, hoping not to accidentally copy and paste incorrect rows to another spreadsheet
- pay top-dollar for a solution that will eliminate the need to perform such a manual break out process, or
- find a low-cost solution that will do the heavy-lifting for you, while ensuring files are broken out, formatted and named in a consistent manor.
A person needing to break out a few spreadsheets may choose the first option. The second option should appeal to a person or department that must do this exercise regularly and for a large population. People that have responsibility for providing spreadsheets to tens, or even a few hundred people, should consider the third option. In today's tough economy, why spend money for a high-cost solution when you can resolve issues with more low-cost, efficient solutions?
Check out this video to see how the consolidation tool works and how it can help you.
E-mail me directly at firstname.lastname@example.org for more information.