Create 2 CSV files From Main Workbook

[vikas_newports]

I want to Generate 2 CSV files which Contains information as available in (Result for Bank) and (Result for CSV) sheet of the attached file
The Main Source data is available in Salaries Sheet

SOURCE FILE (GDrive)

For Bank Sheet
Date will be 27th of every month; and Date Identifier is 1
Debit Account Number is Fixed,
Amount column is the Net Salary
BEN.name is the name of Employee BEN.ACCT is the BANK ACCOUNT
BEN. REFERENCE is the Month name
BEN. SORT. CODE will be lookup from Bank Codes Sheet
BEN. BANK is the name of bank of employee


For CSV Sheet
Phone# is the first column and Agent will be 2nd column and Third column will these
Name "your salary for" Month "is" BASIC 35000 PHONE 5000 GROSS 40000 "Payee" 1300 NET 38700

The above salary details part will contain information if the amount is available in the heading
for example, if the phone amount is available then it will show in the message
The deduction sum will be shown as Payee in the message

So the Leaves Arrears Phone Bonus OverT payee have amount then they will be the part of the message otherwise not.

I am sure you expert will help me in this regard

Please note this is cross forum Post. I am Posting Here because of No Response. Links are as under
Link 1 Link 2