Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2004
    Thanked 0 Times in 0 Posts

    Import Data From Web (Excel XP)

    I need to import some data from the intranet to excel. Cut n paste it comes in the format as per the attached txt file. I'd like to format the data across a row, rahter than down a colum as it is at the moment. There are about 537 records that I need to update in my spreadsheet... I've tried to play with the Web Data Import tool, but it just imports the data the same way as I can manually therefore not much help. Has anybody got any tricky ideas how to write a macro or create a form that will format the data as I need it?
    BTW - each record is on a fresh screen, so I've been manually trawling.

    Thank you - Marco

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Import Data From We (Excel XP)

    I don't know how exactly the data look in Excel, but you can experiment with transposing them:
    - Select the data.
    - Copy to the clipboard (Ctrl+C)
    - Click somewhere else.
    - Select Edit | Paste Special...
    - Tick the Transpose check box.
    - Click OK.

Posting Permissions

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