Hi Hans and all,
Refer to my earlier post which state that :
Can we write code for the auto insert of empty cells with reference to another cell? ie if some of column B’s cells are blank and I would like to input Abbr. or a 2-characters eg. CA into them by looking at the content in the cells of column D , eg California.? an Example in the file would be Belgium in Column D (Country) and Abbr ( column A) would return BE and so on.
Is there another way to delete column automatically instead of using the recording marco as it is static and does not change if the new worksheet change its content to another column?
I have attach a sample for your reference. The column to be delete are column B (address) and Delivery date ( column E). It would be delete before insert the Abbr. describe above.
Your help and suggestions is very much appreciate.
btw, if I program it in my home PC which installed Office XP, can I use the program in my office which run Excel 2000?
Thanks , kun