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.
Excel
Jul 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.