Hi! I am using Excel 2007. I know enough to be dangerous but rarely write code from scratch.

This is what I am looking for:

Look in Sheet 1, cell A1. If A1 contains "Clinical", go to G14 and clear contents of G14.
After clearing G14 or if A1 doesn't contain "Clinical", move to Sheet 2, cell A1.
Look at Sheet 2 A1. If Sheet 2 A1 contains "Clinical", go to Sheet 2 G14 and clear contents....etc.

This file has 30 or so sheets to run through. I have multiple functions I will have to do (besides clearing G14). I may need to look for other text and delete certain rows. I can probably write that if I get the basic IF and loop set up.

I haven't had good luck with IF statements and haven't tried writing a loop.

Thanks for any and all help!!