LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default import data (html files)

Ok guys I have another BIG question.
PART 1) I want to import data (html files) into a workbook from my PC
I have a program that exports html files I need to import the files to excel
then find names in differant sections of the file.
Column B contains the names
the sections of the html that seperate the names are Class:(Nitro Truck),
Class:(Monster Truck), Class:(1/8th Buggy) in excel its merged cells the row
changes depending on how many names are in each section.
I want to import the file then copy all the names to column G if the name
appears more than once put how many total times it appear next to the first
place in column G it appears in column H and delete the other duplicates. If
it appears once then just put a 1 next to it in column H
See excample of page to import at http://www.wichitarcraceway.com/eor1_4.html
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel saving pivot table and data as html files [email protected] Excel Discussion (Misc queries) 1 December 13th 07 06:47 PM
Import HTML data into Excel - data in "1-1" format translates to J PaulT Excel Discussion (Misc queries) 2 December 6th 06 06:28 AM
Import External Data Non-HTML Table Jay637 Excel Discussion (Misc queries) 0 March 9th 06 04:37 PM
Import data from multiple excel files Arlan Excel Programming 1 December 22nd 05 08:19 PM
HTML TAGS that format Data for import into Excel Warren LaFrance Excel Programming 1 November 5th 03 03:46 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"