Update Script

[mossman65]

Hello, i read a post that was solved (link below) and i'm hoping someone may want to help me to.

This is very similar to what i'm trying to do. I too am new to programming in excel.

I have 2 Excel files "Finished Goods" and "Finished Goods List2" that have the same columns in each. All i'm focusing on is columns A (part number) & G (quantity)

The Part#'s in the 1st sheet have outdated quantities.
In the 2nd file the Part#'s are same but the quantity has been updated.

I would like to run a script that will get the Part# from 2nd file and find it in 1st, if it matches then copy the new quantity to the 1st file.

Thank you! Thank you!

http://www.excelforum.com/excel-prog...d-replace.html

[watersev]

hi, mossman65, I'm not the person you are adressing to but the thread title violates Forum rules.

PS. I assume you would not accept help from any other except NBVC so I would not ask anything else