Dear Experts:
I would like to enter the following formula into M5 of all the worksheets of the active workbook:
=IF(A5<>SUM(E5:G5);"Caution!";"ok")
The following requirements have to be regarded
Requirement 1: macro is to skip the following worksheets
1_Index
2_Results
3_Overall_List
X_Data
Y_Requirements
Z_Miscellaneous
Requirement 2: the filled in formula '=IF(A5<>SUM(E5:G5);"Caution!";"ok")' is to be copied down, based on the last filled cell in the adjacent column L
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.