1] I extract data from web site through Macro and VBA. I extract these data in a work sheet column V to AN

2] I copy data from column V to AN in Column A to S in the same work sheet.

3] I copy some data in A to S from V to AN as it is downloaded from web site.

4] In column A to S I do some calculation with excel formula to get some results.

5] I copy data from A to S to another worksheet in the same workbook using excel formula : IFERROR(INDIRECT(A6&"!J27"),"0") and I make a csv file with this worksheet by save as CSV(comma dlimited)(*csv). I export this csv file to another program.

I am facing the following problems.
A] Data which I calculate in column A to S using excel formula and get a result, these are not exporting to another program through csv file.

B] Data which are not using any formula in column A to S are going to another program through csv file

C] Date in column A to S coming from column V to AN as Oct 26,15 are not going to another program through csv file.

Can anyone help me to solve above problem.