Hi,

I have 2 files. 'Reqs Data Entry' & 'Reqs Processing'

I would like to:
1. Loop thru the 'Request IDs' in the Sheets ("Log") of 'Reqs Data Entry' worksheet that has Status (Column "E" - Sheet = "Log" ) of anything else except "Disregard Request"
2. find the Request ID in the 'Reqs Processing' worksheet, Sheets ("Processing")
3. Copy entire row from 'Reqs Processing' and paste to 'Reqs Data Entry', Sheets('Status")
4. Delete any duplicates in 'Reqs Data Entry', Sheets('Status")

I have attached the mock sheets with data.
Reqs Processing.xlsx
Reqs Data Entry.xlsx

I browsed through the internet and had found nothing to help me get started so any help I can get will be great