NewUserPri
New Member
- Joined
- Sep 25, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi People,
I am new to VBA and got stuck in the middle of the project. I will state the whole scenario below:-
So, I have two workbooks namely 1) DailyData 2) MasterFile (This file includes data for all the dates for a month)
I used to transfer whole data from DailyData to MasterFile using VBA code but the problem arises when the data gets transferred twice or thrice mistakenly by clicking on the activebutton.
Please help to avoid this issue and get me a solution by leveraging and using MsgBox warning statement for this.
I want copied data from DailyData to compare data present in MasterFile if it's duplicate then stop the code and exit sub with a msg data already present in masterfile else if data is partially present then add new data in masterfile and donot copy already present data and third if data is not present then paste the whole new data available to masterfile.
Please help if anyone knows how to work through this. I hope you guys get my point if not please feel free to connect by commenting the issue..
Hoping for positive replies. Thanks in advance...
I am new to VBA and got stuck in the middle of the project. I will state the whole scenario below:-
So, I have two workbooks namely 1) DailyData 2) MasterFile (This file includes data for all the dates for a month)
I used to transfer whole data from DailyData to MasterFile using VBA code but the problem arises when the data gets transferred twice or thrice mistakenly by clicking on the activebutton.
Please help to avoid this issue and get me a solution by leveraging and using MsgBox warning statement for this.
I want copied data from DailyData to compare data present in MasterFile if it's duplicate then stop the code and exit sub with a msg data already present in masterfile else if data is partially present then add new data in masterfile and donot copy already present data and third if data is not present then paste the whole new data available to masterfile.
Please help if anyone knows how to work through this. I hope you guys get my point if not please feel free to connect by commenting the issue..
Hoping for positive replies. Thanks in advance...