Advanced Excel Contracts Manager – Generate Unique ID’s

A critical function of any contracts and procurement process management solution is to generate a unique identifier for each process and contract. I cannot stress enough how important it is to allocate an identifier to a process and to use it for all communications regarding the process and the contract, both internally and externally. Why? Because loss of clarity in communications can result in regrettable errors. In addition to that, if you are managing more than a couple of processes and contracts, tremendous efficiency is gained when you include a direct relationship between a communication, document, record and a process or contract. Often the ID's are generated manually by looking at the last number used and adding one, but this can result in duplications through accidentally re-entering the same number and potential inconsistencies through data entry errors. You may mean to type CAT-112 and instead you type CAT-121. Nine numbers have been skipped, which can be confusing, and you may have actually recorded CAT-112 on all your documents and folders. So in this blog we'll look at a method in our Advanced Excel Contracts Manager to automatically generate and ID using Excel and a bit of VBA.

Continue ReadingAdvanced Excel Contracts Manager – Generate Unique ID’s

Advanced Excel Contract Manager – Protect Your Data

It is all well to create a complex list of data, but reviewing, adding and maintaining records in the Excel table format when there are more than a few fields quickly becomes slow and unreliable. End users will complain about having to maintain so many fields, managers will want the data displayed as different forms of information and administrators will quickly tire of trying to fix the errors introduced through poor data entry and accidental deletions. This is where the benefit of the Advanced Excel Contract Manager solution in separating access to and maintenance of the data from the raw data sheet delivers a tremendous advantage over basic spreadsheet tables.

Continue ReadingAdvanced Excel Contract Manager – Protect Your Data

Using Array Variable in Excel VBA to Boost Performance

The array variable provides an opportunity to significantly boost the performance of Excel in processing large data sets and they are surprisingly easy to use. In a recent project, I implemented an array variable and allowed the code run nearly 10 times faster. If you need to manipulate large data sets and your code is running slower than you would like, take a look at this solution.

Continue ReadingUsing Array Variable in Excel VBA to Boost Performance