Link to home
Start Free TrialLog in
Avatar of leezac
leezac

asked on

Delete from Sheet1 based on value in Sheet2

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.
Not-Null.zip
Avatar of [ fanpages ]
[ fanpages ]
Hi,

Just to confirm your expected outcome; in the example workbook provided, there would just be two remaining rows in [Sheet1]:

flour
soda


...or would "Milk" still be present (as it does not match "milk" in [Sheet2])?

Thanks.

BFN,

fp.

PS. Should "beens" read "beans"? :)
Avatar of leezac
leezac

ASKER

expected outcome;  there would just be two remaining rows in [Sheet1]:

flour
soda

Thanks
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leezac
leezac

ASKER

Thank you - works perfect
Avatar of [ fanpages ]
[ fanpages ]
You are very welcome.

Good luck with the rest of your project.