Z
zaw
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
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