Training with Anthony regarding Formating and importing and expo

Hi Shamin, thanks for your queries. First of all, this line of code makes the value of h2 the same as a2:

Sheets("mysheet").Range("h2").Value = Sheets("mysheet").Range("a2").Value

...while this line of code makes the number format of h2 the same as a2:

Sheets("mysheet").Range("h2").NumberFormat = Sheets("mysheet").Range("a2").NumberFormat

So you might want to include that in your loops to ensure the integrity of your data.

Secondly, here's the line of code for exporting data as a CSV file:

ActiveWorkbook.SaveAs Filename:="E:\Desktop\SalesReport1.csv", FileFormat:= _
xlCSV, CreateBackup:=False

I hope this proves useful!

Anthony