ddiag001
01-14-2008, 08:54 AM
Hello,
I manage some product pricing quotation tools based on excel for business software company. When there are changes in pricing, a new quotation tool (QT) is released from the global HQ and then I'm responsible for localizing these the Latin American Regional QTs from the global QT.
I want to set up a macro which compares specific values in specific cells in two different tools (excel workbooks) so that if the values do not equal, it will display a " Failed" message in a specific cell on the new QT.
The purpose of this is to compare the two QTs and to test the differences between the new released QT and the current QT which is going to be replaced.
I want to be able to use this macro everytime I have a new QT so that I can compare these values. Is there a way to set up this macro so that it's not could be applicable to different workbooks?
In addition, after the test, I want to be able to remove this macro or any coding from the QT.
Thanks for the help.
I manage some product pricing quotation tools based on excel for business software company. When there are changes in pricing, a new quotation tool (QT) is released from the global HQ and then I'm responsible for localizing these the Latin American Regional QTs from the global QT.
I want to set up a macro which compares specific values in specific cells in two different tools (excel workbooks) so that if the values do not equal, it will display a " Failed" message in a specific cell on the new QT.
The purpose of this is to compare the two QTs and to test the differences between the new released QT and the current QT which is going to be replaced.
I want to be able to use this macro everytime I have a new QT so that I can compare these values. Is there a way to set up this macro so that it's not could be applicable to different workbooks?
In addition, after the test, I want to be able to remove this macro or any coding from the QT.
Thanks for the help.