Results 1 to 2 of 2
Thread: Import Data From Web (Excel XP)
2005-04-25, 12:09 #1
- 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
2005-04-25, 12:10 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.