Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
okay, I have a file in microsoft excel. I have a column in there for a
description. However, my resource of all the descriptions are in html files. All that is in the file is the description., I also need to be able to match up either the name of the html file or one of the numbers in the html file to a catalog number in excel so that the right description gets put on the same line as the item. The title of the html file is the same as the item # inside the html file. Is there anyway to pull the text out of the html files, with still keeping the model # or whatever in excel? (i.e. file number is 12345, and I have a column in excel with the same number 12345. I would like to be able to match the neumbers up so they would be in different columns but on the same line. I will send anyone the files, if they want to take as look at the files, etc... Please let me know if you understand what I am talking about. I know there may be othe rprogs out there, or even excel . I kjnow its pretty powerful. the column I want the description to go into would either be column F or G. I would ike it if the # in the column for images could be matched up to the number of the file, or # inside of file, to column F or G. SO I do not have to sort all of these 1 by 1. But be able to paste them all in the oprder of that #. Also, if this is possible, to be able to take as many of ther html files at one time, SO I do not have to do all of them 1 by 1. I have around 22,000 products I have to do this with. So I am looking for the easiest way to get all of these in there. someone told me there might be away to do this using macros, but I have no idea. Thanks for any help you can give me. Glowinafuse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) |