Dear all,

I have an easy problem that I can’t seem to get sorted and it’s getting frustrating being so poor at VBA.

I need a macro that will automatically copy the cell value entered in columns B, D, F, H into the same row, left adjacent column (i.e. columns A, C, E, G respectively) only if those cells are blank.

E.G.

When I enter 03/04/2014 into D3
If C3 is blank then
C3 = 03/04/2014

If C3 = 02/04/2014
then do nothing


Thanks boffins.