I am trying to create an automated report that will have a bit of information in it.
Basically I have a table full of customers energy and revenue on a 24 month period.
The values on the table are horizontal, rev1-rev24, energy1-energy24, with rev1 being the most current date and going backwards...
I have a function that locates a table on a webpage and pulls the html code into one cell in a worksheet. Basically we can call this one cell a text file. I need to parse through this text file (cell A1) to create a table. This text file only has info for 1 table, the table always has 12...
I am trying to extract a web table from an intranet website at work and paste into a worksheet in my current workbook. I was able to find a post that really helped me out with this, its shown below.
http://www.tek-tips.com/viewthread.cfm?qid=1369462&page=28#post
My only question is how to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.