UPDATE MACRO

[Candyman_mm]

How do I design a macro that will automatically update my table with information from an outside (excel)source, then search for liked values and return the value "0" if numbers agree. For example, if I have $200.04 in my existing database and my upload returns a value for ($200.04) being the opposite then my total is "0". can this be done?

 

[Jack Cowley]

I would probably use code to loop through the fields but what happens if you have 2 or 3 values that are $200.04? Do you change those as well?

 

[Candyman_mm]

Good question, I have used identification numbers for each dollar amount so the macro will have to read from the indentifier which links the relationship, then calculate both amounts to return the differnce, if any.