I need to copy value from cell B3 in cell C4:C5 and then value from cell B6 in C7:C14 and then value B15 in Cell C16:C19, etc. intervals are always variable. Is there any VBA code I can use to do this with just a few clicks?. Many thanks