Dear Sirs,
Each month, I’ve to print a report file, say for Apr16 Report, and then check with the previous month Mar16 Report file, and perform the following procedures :
1. Check Mar16 Report to Apr16 Report for matching Worksheet Name, if found, then
2. Check column A in Mar16 Report to Apr16 Report for matching Project Number, if found, then
3. Copy cell comments only in columns F/G/H from Mar16 Report to Apr16 Report (same columns F/G/H)
4. The process is repeated for all the worksheets in Mar16 Report
Since this is best to automate by VBA codes, and I would like if anyone could offer assistance, as this seems beyond my capability who know only macro recording at best.
I also attach sample files for your reference.
Thank you in advance.
Edward
Bookmarks