I tried coping and pasting the following webpage: http://www.bedford.k12.ma.us/extra-c...directory.html into separate columns in a workbook. However it will only go into one column. Any ideas?
Last edited by warreng33; 09-25-2011 at 07:34 PM.
I was able to do this using data web query.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Alan, thanks a bunch I have never used the web query functionality before. With a little trial and error I figured it out, thanks so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks