Hi, I have a requirements in vba excel to evaluate if cell value in column D is empty and if cell in column A has a value then i need to fill up the column D with a string 'IN-TRANSIT". May I ask your assistance on how to do this in vba macro. thank you in advance.

sample data

Column A--------B------C----D----E------F
Transaction#---Label--Qty--ETA--Model--Status
---------------------------------------------
8840863172-----IPH1---5---31-Aug--mm--RECEIVED
8840863172-----IPH2---5---31-aug--mm--RECIEVED
8840863216-----IPH1---2---     ---XX-- 
8840863216-----IPH2---2---     ---xx--  
8840863216-----IPH3---2--      ---ll-- 
8840863216-----IPH4---3--      ---ll-- 
8840863216-----IPH5---3--      ---ll-- 
8840863216-----IPH6---4--      ---ll-- 


RESULT


Column A--------B------C----D----E------F
Transaction#---Label--Qty--ETA--Model--Status
---------------------------------------------
8840863172-----IPH1---5---31-Aug--mm--RECEIVED
8840863172-----IPH2---5---31-aug--mm--RECIEVED
8840863216-----IPH1---2---     ---XX--INTRANSIT 
8840863216-----IPH2---2---     ---xx--INTRANSIT  
8840863216-----IPH3---2---     --ll--INTRANSIT 
8840863216-----IPH4---3---     --ll--INTRANSIT 
8840863216-----IPH5---3---     --ll--INTRANSIT 
8840863216-----IPH6---4---     --ll--INTRANSIT