Forum Discussion
Excel
Jul 14, 2022Iron Contributor
Query related to stop code message with the help of VBA code
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 ...
- Jul 14, 2022
That's impossible as far as I can tell.
HansVogelaar
Jul 14, 2022MVP
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.
- ExcelJul 14, 2022Iron Contributor
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"
- HansVogelaarJul 14, 2022MVP
That's impossible as far as I can tell.
- ExcelJul 14, 2022Iron ContributorThank you so much sir.