Macro to Lookup an item and bring its comments!

[amattey]

Hello,

I have a spreadsheet that creates a new tab monthly with new data. However, sometime the new month data might have some repeated from the past month in which we input some comments. Is there a VBA macro to lookup similar data from the current month tab into the last month tab and bring the comments? Could anyone help? Will much appreciate the help.

 

[amattey]

This is what I have but does not seem to work:

Sub Get_Manual_Comments()
     
     Dim p As String
     Dim mon As String
     Dim ye As String
     
     mon = Month(Now() - 1)
     ye = year(Now())
     
     
     p = Sheet.mon & ", " & year
     
     Sheets(Format(Now(), "mmmm, yyyy")).Activate
     Range("I7").Select
     ActiveCell.FormulaR1C1 = "=IF(RC[-3]=VLOOKUP(RC[-3],p!C6:C9,4,FALSE),=VLOOKUP(RC[-3],p!C6:C9,4,FALSE),"""")"
     Range("I7").Select
     Selection.AutoFill Destination:=Range("I7:I12"), Type:=xlFillDefault
     Range("I7:I12").Select
 
End Sub