I have the attached example of a file where I need to
do the below:
Delete rows to end of used rows on Sheet1 where
Sheet1 column A matches Sheet2 column C
And Sheet2 column AP is not null
Can someone please help on how best to approach this either using a formula or VBA - preferably vba.
Thanks in advance.