Macro to loop between cells based on other cell value/category

Hello Guys,

I have an small requirement to automate my worksheet.

There are unique App ids present in Column B which are divided in 2 different Types ("Forward" and "New") in Column C. In column F to I there is a current status of App id is present (through V-lookup from different sheets) in the same row.

Macro Requirements:

1. Need a Macro which first check the Type of App id in Column C. If it is mentioned as "Forward" then macro should look for the status mentioned in Column F only and update the same in Column D. But, if Column F is blank or IsError then do not update the Column D. If there is any numeric value is present in Column "F" then Macro should consider it as "Filed" and update the same as an Status in column D.

2. But, if in Column C the App id Type is mentioned as "New" then Macro look for the stauts mentioned in Column F to I. The priority should be like from F to I, means if status is found in column F then macro should not go in next column and update the same in Column D. If Column F is blank or IsError the macro look for status in next column "G", if status found then update else look for in Column H and same process for Column I.

Thanks,