priyajrao26
New Member
- Joined
- Aug 18, 2021
- Messages
- 1
- Office Version
- 365
Hi Guys,
I have an excel master sheet- detailed report and three other sheet- Method evaluation, software evaluation and verification phase evaluation. From each of the three sheets, I have written a code to copy the comments from the last row and paste them in the column B of the master sheet in the first cycle. Now, In the second cycle, if a new comment is added, the new comment must be identified from the three sheets and must be pasted in the master sheet at the end. It should not change the comments that is already existing from the first cycle but just compare the changes and add the new comments at the end of the list in the already copy pasted list. if possible, it should also indicate that the comment was added in the next cycle. Attached is the existing code. Could you please help me with this problem? I have been struggling a lot.
Thank you in advance and Regards,
Priya
I have an excel master sheet- detailed report and three other sheet- Method evaluation, software evaluation and verification phase evaluation. From each of the three sheets, I have written a code to copy the comments from the last row and paste them in the column B of the master sheet in the first cycle. Now, In the second cycle, if a new comment is added, the new comment must be identified from the three sheets and must be pasted in the master sheet at the end. It should not change the comments that is already existing from the first cycle but just compare the changes and add the new comments at the end of the list in the already copy pasted list. if possible, it should also indicate that the comment was added in the next cycle. Attached is the existing code. Could you please help me with this problem? I have been struggling a lot.
Thank you in advance and Regards,
Priya