My First Love

Starting from today, I have decided to include another category to share in this blog.
It will be about my first love.....

I have been using this product for a long long time and to a certain extent, some say that I can't compute 1 + 1 without Excel. That is how dependent I am on this baby.

On the other extreme end, I have worked with Macros, Visual Basic and all sorts of commands to come up with solutions to be more efficient in my previous working life.

It can be very complicated at times but if you know which right buttons to push, you will have it under your spell and will follow all your commands quite willingly.

I love challenges and more so, solving the challenges using Excel. As long as the challenge can be put on a spreadsheet, I could possibly find you a solution!

Duplicate Contact Prompt

Since Patch 206033, there is a new feature in the Contact Maintenance to prompt user that you are potentially keying in an entry which could already be in the system. Whenever the user keys in the data in Surname or Company field, all the entries which carries the same value will pop up. You have an option to select it if it already exist or press cancel if it is a genuine new entry.

This is a very useful feature to minimise duplicate contacts in the system.