Hi, I was looking to create a VBA where it loops down every row in a column (column G, starting in cell G3) and if that is a date I would want to copy the data from the corresponding cell in column H and paste it as a value into column F. Eg if cell G22 has a date it would copy cell H22 into F22 as a value, then carry on down the rest of the file to see if there are any more dates.
Please could some one help with this.
Thanks in advance
Please could some one help with this.
Thanks in advance