+ Reply to Thread
Results 1 to 2 of 2

Please help- manupulating file, deleting columns and Converting to.CSV using macro

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Please help- manupulating file, deleting columns and Converting to.CSV using macro

    I am novice user in Macros. Could anyone help please?
    The project is divided in following parts.

    1) I got a excel file which have a data as per attached 1.jpg

    2) I required a column which is going to use following formula which will calculate the total hours from timesheet
    =IF((F1-D1)*24<0,(F1-D1+1)*24,((F1-D1)*24))
    As per 2.jpg


    3) Finally I only required 3 columns which will be employee no, the total hours which I received in step 2 and date which is in column 3. As per 3.jpg

    Employee number, total hours worked and date (which is in DD/MM/YYYY)
    The total hours worked are formatted to 2 digits.


    Finally, After getting output as per 3.jpg. The file required to convert in .csv format and require to save on local drive

    Thanks in advance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Mdesh; 02-10-2014 at 10:33 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: automatically creating .csv files from .txt files with specific format and formula

    Try recording a macro to do what you want then working from there?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Creating specific CSV txt files from excel
    By robfeels in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2013, 12:07 PM
  2. [SOLVED] Need Help for creating a Macro to extract specific data from all files in a folder.
    By shaiq123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2013, 02:08 PM
  3. Replies: 0
    Last Post: 03-15-2012, 04:13 PM
  4. Replies: 2
    Last Post: 03-01-2010, 04:39 PM
  5. Replies: 11
    Last Post: 01-03-2009, 06:29 PM

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