Using "For Each" loop VBA in Ms Excel

For each name in the workbook,I wish to add 1/the value in the B cell of worksheet1 and 1/the value in the C cell of worksheet2 *100 and display the result if less than 100. This same process is repeated for worksheet1 and worksheet3 and on until worksheet10. The iteration now starts from worksheet2 and worksheet3 and so on until worksheet2 and worksheet10. Iteration continues beginning from worksheet3 and 1/the value in C cell of worksheet4...until worksheet3 and 1/C cell value of worksheet10. The last iteration for the first name in the column would be the use of 1/the value in the B cell of sheet9 and 1/the value in C cell of sheet10. This will happen before the loop goes to the second name and executes the above iteration process all over again until the last Name (Stacy) is looped through with the corresponding iteration through the cells as above and finally displays all values less than 100 through the message box or in some cells of the workbook.

Duplicate post. Please read rules:
https://www.excelforum.com/forum-rul...rum-rules.html