Results 1 to 3 of 3

Thread: Need urgent help to get macro, plz help

  1. #1

    Question Need urgent help to get macro, plz help

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am new to macro's & my boss have assigned me work to create macro, as of now I am just copying the below files after editing from ultra edit in excel sheet from unix
    I am good in shell scripting so the task is like below:

    Size Month Date Time File Name Volume
    1000 Aug 13 19:03 abc_123_201209102003072965_abc.bin-20120910200404
    1000 Aug 14 19:03 abc_tcatnf_123_201209141902220126_abc.bin-20120914190310
    1000 Aug 15 19:02 abc_tcatnf_123_201209131902314532_abc.bin-20120913190250
    There are hundreds of different file names like above

    I need to create macro like this:

    I need to copy all the information like above which is in a scattered way to one tab of excel sheet & the main information will be populated in the second tab in the above format in the excel sheet.
    I know I am asking everything but i have no time for learning I am really thankful to anyone who will give the solution to the above problem.
    I am also attaching the sample excel sheet.

    Thanks & Regards,
    Attached Files Attached Files
    Last edited by Beginner@123; 2012-09-17 at 10:05 PM.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Post an example of the results so we can see what you want to do.

  3. #3
    Thanks for the reply.

    if you see the attched sheet I have dumbed the raw data in one worksheet & in the second sheet i want it to populate the data under the header:

    Size Month Date Time File Name Volume

Posting Permissions

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