Link to home
Create AccountLog 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

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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of leezac

ASKER

Thank you - works perfect
You are very welcome.

Good luck with the rest of your project.