Automation in excel

  • Thread starter Thread starter zaw
  • Start date Start date
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
 
While I'm sure Excel could be used to do what you want, it would require you
to learn about the Excel object model, etc. That's seem like a big time
investment for this one exercise. If Perl (which I have no experience with)
is something you know more about, and it can be used to do this job, maybe
that's a better route?
 
Back
Top