The code below puts a static value of 2015/03/31 in cell K3 then copies it down column K until there is no data in column G. How would I edit this to do the following?
1. Have the MyRange.Value = todays date plus 7 days
2. As it copies that value down column K, as long as there is data in column G, have it increment to the next day for each row. So today is the 22nd, it would put the 29th in K3, 30th in K4, 31st in K5..... and on down, until column G is empty.
'' Set MyRange = Range(Range("K3"), Range("K" & Range("G3").End(xlDown).Row))
'' MyRange.Value = "2015/03/31"