+ Reply to Thread
Results 1 to 2 of 2

Create 2 CSV files From Main Workbook

  1. #1
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 365
    Posts
    237

    Create 2 CSV files From Main Workbook

    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

    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

    Cross Post Links Because No Response From Here
    Link 1
    Link 2
    Attached Files Attached Files
    Last edited by vikas_newports; 11-17-2020 at 12:38 AM. Reason: Cross Post Links Update

  2. #2
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 365
    Posts
    237

    Re: Create 2 CSV files From Main Workbook

    is any expert take a look at this .please

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create pdf files from a workbook
    By menjol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2020, 03:21 PM
  2. [SOLVED] How to export code from a text editor in the main workbook to a text editor for many files
    By Feisty2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2018, 01:36 PM
  3. [SOLVED] Create a new workbook from a template worksheet using information from main workbook.
    By nathandavies9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2017, 11:28 AM
  4. [SOLVED] Create New WorkBooks based on conditions from main workbook
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-19-2014, 03:56 AM
  5. [SOLVED] Create CSV files from 2-3 worksheets from workbook & keep workbook intact
    By clage in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 01:15 PM
  6. Using Vba create another workbook then update the formulas of main workbook
    By rename in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 06:12 AM
  7. [SOLVED] Create multiple new files with names taken from another workbook
    By KCK01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2012, 08:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1