Hello,
Can someone help me with a VBA code for below pictures?
In column "Final Status" in this moment i have a lots of "IF" formula to show me the status of the line and i have a lot of columns.
There is a VBA code which can complete each cell with the correct status?
In this moment my formula in the cell is:
=IF(AND(C31<>"",D31="",I31="",J31=""),"Cat 0 P",
IF(AND(C31<>"",D31<>"",I31="",J31=""),"Cat 0",
IF(AND(C31<>"",D31<>"",I31<>"",J31=""),"Cat 3 P",
IF(AND(C31<>"",D31<>"",I31<>"",J31<>""),"Cat 3",""))))
Can someone help me with a VBA code for below pictures?
In column "Final Status" in this moment i have a lots of "IF" formula to show me the status of the line and i have a lot of columns.
There is a VBA code which can complete each cell with the correct status?
In this moment my formula in the cell is:
=IF(AND(C31<>"",D31="",I31="",J31=""),"Cat 0 P",
IF(AND(C31<>"",D31<>"",I31="",J31=""),"Cat 0",
IF(AND(C31<>"",D31<>"",I31<>"",J31=""),"Cat 3 P",
IF(AND(C31<>"",D31<>"",I31<>"",J31<>""),"Cat 3",""))))