Create 2 CSV files From Main Workbook

vikas_newports

Board Regular
Joined
May 26, 2016
Messages
121
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,127,558
Messages
5,625,503
Members
416,114
Latest member
Ayush_123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top