Hi Friends,

I need a help!!!

Every month I get close to 80 excel reports. Every report has a unique name. The name will be consisten across months. I analyse each document and enter my comments on the 'Comment' Column which is the last column of each sheet. The data present in the preiovus month will be present in the current month, so i need to copy the previous month's comments to this months report. No need of VLOOKUP kind of search, just copying... since the order of the data will be the same.

The macro should consider the previous month folder and current month folder and copy the comments from previous month report to current month based on the uniqueness of report names.

It would be a great help if you can look into this.