Results 1 to 1 of 1
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transfer data into specific Columns (VBA.MS.excel 2000)

    hi all,
    i really need some helps and guidance on this matter if anyone have some ideas.

    i will to import a deliminated text files into a worksheet at excel. The data from the txt files
    will be in the layout base on the following tables:
    currency_code 4 char,
    currency_year_month DATE,
    currency_exchange_rate FLOAT.

    thus, sample data frm text file would be :
    USD,JAN-2001,1.83
    USD,FEB-2001,1.79
    USD,JAN-2002,1.80
    USD,FEB-2002,1.80
    USD,JAN-2003,1.79
    USD,FEB-2003,1.79

    Once i imported the text files into the worksheet at excel, i need the data to be placing
    into the respective columns eg:

    <pre>currency mth year exchange rate mth year exchange rate ......
    USD JAN-2001 1.83 FEB-2001 1.79
    USD JAN-2002 1.80 FEB-2002 1.80
    USD JAN-2003 1.79 FEB-2003 1.79
    </pre>


    I have attached a sample excel worksheet which i need the data to be place. how can i do this tasks
    izit there is functions in excel or VBA can perform this....
    thanks in alots.


    **edited by Rory:
    This is cross-posted in Excel <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=68333&page=0&view =expanded&sb=5&o=0&fpart=>here</A> so I've copied the attachment and locked this thread. Please post any responses in Excel.
    Attached Files Attached Files

Posting Permissions

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