Dear Sirs,
I've a monthly routine to print out a report for a month, say Apr16, and is required to make reference to Mar16 report to do the following boring copy and pasting :
1. Check matching worksheet name in Mar16 Report with Apr16 Report, if found, then
2. Check matching project number in column A, if found, then
3. Copy cell comments (annotations) only from Mar16 Report for 3 columns F, G and H to Apr16 Report (to same columns F, G and H)
The work procedure is simple but repetitive, and best to automate by VBA codes.
I enclose the 2 sample files for your reference.
Would be grateful is someone could help.
Thx so much.
Bookmarks