Hi All Excel master,
I have file excel AB10 it contain raw data need to be edit and put in new workbook AB. Raw data contain a few unused column so i need to delete it and then i also need to insert some columns with excel formula. Here i Attach the file,
1. i need to delete P column.
2. i need to insert 2 column after N column with formula in O column = (N10-O$8)/30 and P column =IF(O10<=1,"(0 - 1 bulan)",IF(O10<=3,"(>1 - 3 bulan)",IF(O10<=6,"(>3 - 6 bulan)",IF(O10<=12,"(>6 - 12 bulan)",IF(O10<=24,"(>1 - 2 tahun)",IF(O10<=36,"(>2 - 3 tahun)",IF(O10<=48,"(>3 - 4 tahun)",IF(O10<=60,"(>4 - 5 tahun)"))))))))
please kindly help me to solve this problem using macro. Thanks in advance
Bookmarks