Automating excel file update
 

Hi, I would like to automate some work I have to do everyday. I have
some programming background but not with excel or Access. Anyone can
help me with the following, I appreciate it. I am not even sure it can
be done.

If I need to read some material or books, please let me know. I was
thinking to write perl program, but if you can suggest easier method
that would be great.

I have 2 product list files in excel format. My goal is to update
inventory in the first file from second file.

Let's say the first original file has the format as follow:
"Product#","Name","Description","Price","Inventory "
"0001","Product A","An Apple","$1.00","3"
"0002","Product B","A Book","$5.00","18"
"0005","Product E","An Eraser","$1.50","5"
"0009","Product I","An Icecream","$0.50","21"

*There is skip in product#.*

Second file has similar format. But it doesn't have all product# that
first file has and it has product# that first file doesn't have.

I would like to update products in the first file from second file, I
do not care about product# that first file doesn't have. I will leave
as it is for the products that second files doesn't have.

For example, I will update product# 0001, but i do not care about 0003
or 0006. If I cannot find 0005 in second file, I want to keep its
inventory as it is.

Thank you in advance for any help.

Shwekhaw