I am looking for help to create the best macro that will transfer for me the information as it appear in the attached workbook sheet(sheet2) column A&B to Column E , basically this is the transfer of lotus macro to excel VBA macro which I have done myself . the problem is that I have many of those and I am trying just to save time and therefore I am looking for macro to do that any idea ?????