We live in a world of information. In this modern context, we have come to the point where it is no longer about the lack of data but too much of it. Navigating around this massive data often cause much grief to end-users. Our filing system has become a dumping ground for information that we receive from time to time, or perhaps on a daily basis.
Finding a way to navigate our electronic filing system is something that i struggle with. The main issue is sorting out that “dumping ground”. I decided to take the challenge in writing up an excel macro to allow me to organize this dumping ground by creating hyperlinks to files. This will allow me to track the location of the files and also allow me to code it up so that i am able to locate it at a subsequent time.
- Make a backup copy of this “dumping ground”. Place this backup copy on a specified location or folder on a separate drive or server.
- The sorting process will be applied on to this backup location where we can create an organized filing system out of this “dump”.
- Using Excel, we can create a one-page menu of this “dump” where there will be hyperlinks to each of this file.
- We also create a column where we can start placing general categories on each of this file so that we may group them into a more orderly fashion.