This was very helpful Mandy! I am left with one more problem. How can I get it to prompt the user if the total becomes larger than 100?something like Total value can not be larger than 100.Thanks for any help you can give!Here is my version of the code you gave$ = Sum(FabricDeatilsRow1[*].FabricPe...