I've got this which updates a cell with a formula;
If Not IsEmpty(Range("A8").Value) Then
Range("D8").Formula = "=A8 & "" "" & C8 & "" "" & B8"
This code is repeated through to A31 resulting in a lot of code and I'm trying to create a more efficient method of doing this, so have thought about...