• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying website tables and pasting them on Excel 2007

G

gwapo

New Member
Newbie here, so please bear with me. :)


I have been tasked by my company to copy tables from our intranet website and paste them to excel 2007. My boss wants the table that runs from top to bottom to be transposed to excel so that she can make filters and sort the data for easier browsing.


I already know a bit about macros and tried to paste the table as plain text in transposed format.


The problem is there are close to 700 tables. I would like to paste all of them and make them populate another table automatically one by one when I paste them first on a preliminary sheet.


I have been thinking about vlookup but I can't seem to go around this since I need to paste each table on the exact same sheet, delete it for the next table and make the data populate a table on another sheet.


Or is it possible to paste transpose the table to the template table without pasting the column titles.


Please share your expertise with me. What is the simplest way to do this and what would be the simplest formula on Excel.


Thanks in advance!
 
I'd be talking to whomever in your business setup your intranet

They are most likely running Sharepoint which sits in front of SQL server

They should be able to give you access to the orginal data in a much more streamlined fashion than copy/paste
 
I work for a large company and the problem is bureaucracy. The IT department even in our site does not allow us to access data beyond what we can view.


I wish there would be a way for me to do this. I think there is. I just don't know how. :)


Thanks for the replies. Hope you guys would continue replying to this question.
 
You should have ODBC access to your databases, this allows you to read the DB into excel without writing access,

Ask for it if you don't have access
 
-----

I work for a large company and the problem is bureaucracy. The IT department even in our site does not allow us to access data beyond what we can view.

-----


No! Say it ain't so.
 
You must log in or register to reply here.
Back
Top