G
Glowinafuse
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
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