whenever i run macro on cell like F13 it copy the date of F13 to cell BC1 and then copy value of cell C4 and paste it in adjacent cell of F13 i.e G13. But what i want it paste value special in adjacent cell so that when i run the macro on another date like cell F14 then calue of cell G13 did not get change and one more thing is there a way that macro automatically run on aeach cell i.e. from F5 to F30 and keeps on pasting value in the adjacent cell so that i do not have to run macro again and again on every cell i,e F5 to F30.
[ATTACH=JSON]{"alt":"Click image for larger version Name:\tUntitled.jpg Views:\t1 Size:\t57.2 KB ID:\t1205138","data-align":"none","data-attachmentid":"1205138","data-size":"full","title":"Untitled.jpg"}[/ATTACH]
Code
Sub Macro1()
ActiveCell.Copy Range("B1:C1")
Range("C4").Copy ActiveCell.Offset(, 1)
End Sub