Microsoft Excel VBA and Macros is an exceptional value for those wanting to significantly increase their productivity using VBA and makes a great addition to your library.
I recently discovered a website titled “Excel Off The Grid” while doing some research for one of our projects. The post I read was well written, succinct, and the examples were easy to follow. Although our application required a little more depth, the information presented would be more than sufficient for most people wanting to use the features as discussed. […]
Editing or updating records in a database using Sticky fields can save a lot of time by avoiding repetitive data entry.
Background Not too long ago, I was approached by a systems consultant to consider writing an Excel solution to create a weekly production schedule for one of his clients. The reason for using Excel will become clearer in a moment. The current process Sales representatives submit a unique Excel spreadsheet / file for each customer order. All orders are saved […]
- Advanced Lean Manufacturing
- Eliminate Waste
- Lean Metrics
- OEE: Overall Equipment Efficiency
- Problem Solving
- Process Control and OEE
- Standardized Work
Background: VBA for Excel has once again provided the opportunity to demonstrate some basic lean tenets. The methods used to produce the required product or solution can yield significant savings in time and ultimately money. The current practice is not necessarily the best practice in your industry. In manufacturing, trivial or minute differences in methods deployed become more apparent during mass production or as […]