Hi, I'm new to VBA, so any help would be appreciated. I'm trying to move values from 2 separate workbooks--'CT' to 'FAWB'--given certain conditions. When i run the macro below, Excel doesn't prompt an error message, but there are no values moving from one workbook to the next, so I'm not sure what the issue is.

Here are the events that need to take place:
If:
condition 1: Value in column H of CT.SPview= 'FA'
condition 2: Value in column B of CT.SPview doesn't appear in column B of FAWB.IRSheet.
Then:
copy paste values where conditions 1 and 2 are met into next available row of FAWB.IRSheet.

Below is the code that was used. 
Please Login or Register  to view this content.
Thanks in advance for the help.