Hello,

How do I have a column automatically insert a name depending on the text in the next column?

The macro code I have will copy the report to a master book. However, in the report, there isn't any fleet name for the people to fill in. So depending on the flag name in the report, the master book will have the fleet name.

Example :
E3 (Fleet) - SIN
F3 (Flag) - Singapore (already copied from report)

E4 (Fleet) - MAS
F4 (Flag) - Malaysia (already copied from report)


This is what I have. So as you can see Cell E is not there because it has to be manually keyed in. 

With Sheets(1)
lastRow = dstSht.Range("B" & Rows.Count).End(xlUp).Offset(1, 0).Row
'General Information section
dstSht.Cells(lastRow, "B").Value = .Range("G2").Value
dstSht.Cells(lastRow, "C") = .Range("AB3") + .Range("AF3")
dstSht.Cells(lastRow, "D").Value = .Range("G4").Value
dstSht.Cells(lastRow, "F").Value = .Range("U4").Value