Hi,

I am using Excel 2003 to update my website with products from my suppliers
website. So far, if I keep going at the current rate, it'll take forever.
Could someone find a way, or a macro that would speed this process up for me?
:

Process - I copy a list of products and their product numbers from supplier
website, paste into excel using unicode text in special paste function,
select all values in column "A", use drag function to move values down 1 row
to match values in column "B", Highlight all pasted items, press F5 for the
"go to" menu, select "special", then "blanks", go to Edit, delete, entire Row
(to remove all blank rows), select all of column "B", click "sort ascending"
function, select "expand the selection", click sort. Then I compare the items
in this spreadsheet with a complete list of items in another, if value of
column "B" (the product name) are the same (sometimes the first spreadsheet
is missing a few items), then I copy the items' corresponding item number in
column "A" onto the other spreadsheet with the complete list of items. Then
I manually fill in any missing item numbers.

This whole process is essentially for synchronizing the item numbers with
the same item numbers of the supplier. I guess a simple solution would be to
generate my own item numbers, but if I did that, it would make the process of
importing all the product images ALOT harder. So if anyone could PLEASE help
simplify most, if not all of this with some kind of macro, or simpler
process, I'd greatly appreciate it.

Much Thanks
--
„¢Â»ZrÃ¥xïûš«