Updating between spreadsheets using VBA

Hi,

Im hoping my query will be rather straightforward. 
I have two worksheets. One is holding the core data, the other is pulling filtered data through using a combo box. 
There is a single field on this filtered worksheet which needs to write back to the core data sheet however it needs to pick up the row reference. 

At present I’ve got it sent up so that when a value is entered into the filtered sheet it’s picking up the target address. This target address is the ID number from the core data table. 

essentially I need something that says if target address = a value in core data.ID column (in this case it’s a value in column A) then update column R with the value that’s has been entered in the filtered data spreadsheet. 

so in core data I have 

A.         B.         R

ID.      Name.    Approved Y/N

1.         Joe.        

2.         Pete

3.         Frank

4.         Ian

and in worksheet2 which is filtered by the combo 

ID.          Approved

3.                Y

4 

as the filtered table gets updated it needs to write the Y