Query related to stop code message with the help of VBA code

[Excel]

Hello Everyone, 

I have 2 questions :

1st question - After run the in YEARLY REPORT, Whenever i add data in EAST SHEET

like - 

then again in run the code , then it update but it will show repeat data in downside

like - 

2nd question - How to stop the loop if once the formatting,auto sum and copy paste is done ? It would be better if some kind of pop up msg can inform that the said works have already been done . And some more dynamic coding to run only on those part for which the said works are not done.

Please help..

Here is a attached file...

[#2]

@Excel 

It is impossible to know which rows have been copied and which ones haven't, since the individual sheets contain duplicated rows. For example row 3 and row 22 on the EAST RECORDS sheet are identical.

So we have to keep track of which records have been copied another way. See the attached version.

[#3]

@Hans Vogelaar 

After run the in YEARLY REPORT, Whenever i add data in EAST SHEET

like - 

then again in run the code , then it update but it will show repeat data in downside

like - 

What code should i write without giving Copied column as well as not show "X"

[#4 · Accepted solution]

@Excel 

That's impossible as far as I can tell.

[#5]

Thank you so much sir.