I have requested that please solve this issued if it could be solved.
I have found major drawback (May be I am wrong) in the code of Copy data and Clear Data is that whenever it executed, the ruining VBA Code is stop working.
Is Their any possibility that running code is function properly.
Copy Data Code
Worksheets("311").Range("B11:E510").Value = Worksheets("301").Range("B11:E510").Value
Application.CutCopyMode = False
and Other Clear Data Code
' ClearData Macro