Good Day,

I am working in a share market where i have to use Excel a lot to prepare the reports . Now i am facing a problem with one report which have to be upload every day to Exchanges. Daily i am getting files from Exchanges the files are as under format.
MCX_MARGIN_00000_yyyymmdd.csv - Received file

here in this file i am getting the margin report and the file consists of 'n' no of and using 13 columns that means upto M:M
So in the place of N:N i have to paste the values from M:M( Means copy M column and paste it in N column ) and then
the file has to be saved in other format which consists of .M01 (if the file is fails then i have to give .M02... like wise)

MCX_MARGIN_yyyymmdd.M01 - Report file
i need to give the report file in the above format where yyyymmdd is as same as the received file from exchange and in this report file column A:A consists of date which is in the format of ddmmmyyyy

Kindly help me to solve this issue

Regards

Witson Joyet