Copying from one workbook to another when condition is met|VBA & Macros|Excel Forum|My Online Training Hub

Hello,

I have cut a small section of a report that i want to create a code for. The idea is to cut the notes on column P from yesterday to today's report so i don't have to manually cut and paste them.

Goal: If PO number from column B(Purchase Order Details by Vendor (2019-11-01)) is equal to PO number from previous day(Purchase Order Details by Vendor (2019-10-31)) then copy the notes to column P for today's workbook. 

Challenges: the PO# will be on a different row day by day as Purchase orders close or open.. so for example PO 009313 might not be on row 26 on Nov 2nd's report.

I only got the code to open the workbooks on my desktop and i am still researching on how to do the rest. 

What i got so far:

Option Explicit

Sub Open_workbook_Basic()

Dim dd As Integer

Dim mm As Integer

Dim yy As Integer

dd = Day(Date)

mm = Month(Date)

yy = Year(Date)

Workbooks.Open Filename:="C:\Users\Eric Lau\Desktop\CCI\Purchase Order by Vendor REports\Purchase Order Details by Vendor (" & yy & "-" & mm & "-" & dd & ")"

Workbooks.Open Filename:="C:\Users\Eric Lau\Desktop\CCI\Purchase Order by Vendor REports\Purchase Order Details by Vendor (" & yy & "-" & mm & "-" & dd-1 & ")"

End Sub

I would appreciate it if anyone can help with creating the code or linking resources or older posts that have requested the same thing. 

Thank you for your help!