Need advice on the code availabe in excel

[aleanboy]

Hi All,

Please find attached macro file. I am stuck in between.

Once you run the macro, you will notice that entire column "R", "S", & "T" in sheet named "Sep 23rd - Stores" are getting reiterated.
Code I have problem is in the below

Please Login or Register  to view this content.

And also, when I use below code, it is not removing the formula, please advise.

Please Login or Register  to view this content.

Thank you

[aleanboy]

Hi,

Can anyone please crack the issue in code.

Trying to complete this since last week....

Please help

[aleanboy]

Please advise....

[:) Sixthsense :)]

No need of UsedRange in the below line

Please Login or Register  to view this content.

The below code is intended to run on the active sheet or any other sheet? Because there is no sheet reference for the below ranges

Please Login or Register  to view this content.