Hello,

I have a spreadsheet that I call "Master" and another one I call update. I want to be able to Update rows in the Master spreadsheet with rows from the Update spread sheet.

If the update spreadsheet has a row with part_number "123abc" in column "A", I want to update the row in the master that has the count in Column "G" where column "A" (update) matches column "A" (master)




Thank you so much!

Aaron

Hi Aaron,

You don't need macro for this. A LOOKUP formula in the master spreadsheet pointing to the update spreadsheet should do the job. Without more details of the layout & workbook names, etc, specific advice can't be given.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hello and Thank you for your reply!

I have attached and image of the two table, and the macro that i have been trying to get to work, no luck so far

I'm a SQL and PHP and CF person. Excel is so Alien to me right now but i need to learn it seeing it playz a big part with my company.