i am looking for an excel macro to convert the excel file, i am attaching the excel file. once i run the macro i want the out put of the file as Workbook4. I am looking from workbook5 to workbook4 once i run the macro file. and in column c i want where the length is equal to 6 only. if the length is more than 6 then those rows has to be deleted.