The script is set up to run a Find on a field and then copy a sum calculation result and paste to another layout field. This repeats for each Find but the problem occurs when there are no records for a given category at which point the script stops and asks if I want to Cancel, Continue or Modify Find. What I want is for it to skip it when no result is found and go to the next category. How would I achieve this? Is there an 'If’ calculation required?
Thank you very much.