I`m the internal project manager at Sage Pastel South Africa. I`ve always loved working with excel. As a hobby I`ve started developing pricelists and schedules for the sales team to streamline and speed-up the process of creating the initial quote to customers. One can almost say it`s a fancy calculator... In order to get this to work I had to revert to VBA: Excel does the calculations while VBA manage the mode (New, Up-sale or cross-grade); the rules (selecting of related modules, like-for-like modules, Qty`s and pricelist discounts) and management discounts (%/amount). I found this forum very help-full to go through the learning curve starting from scratch. I hope to learn many more functions....
©