Hi,

Am having a multiple tables in a document and i need to validate the sum of each tables in a document manually and it is taking more time and effecting productivity, is there any macro can help me in this regards and am new to the VBA and basic knowledge about this...

Am using excel fot this work to copy the table and calculate sum at the end of the table and apply conditional formatting highlight duplicate values and manlly work on not highlighted values, it is taking more time to do in excel and then again making corrections in word document.

My requirement : format is ".rtf"

Every table last row is predefined total row...

A new row to be added at the end of the table and calculate sum and if it is matches to the above total row it should be in highlighted in green color and if not match red color, then my manully intervention only on the red rows .....

I dont know may be it is possible or not just trying...

any help or suggestions is highly appreciated ....



Please find attachment for examples ...

Thanks ..

Attached Files

test.docx (56.0 KB, 9 views)