Anyone know how to do this or a formula that will help me accomplish this?

If information within Column C of Worksheet 1 is not within Column B of
Worksheet 2, then populate a new row on Worksheet 2 with information missing
from Column C of Worksheet 1.

This is basically what I need.

I need all the missing information within the column to copy everything in
the row of the column item missing. Is there also a way to specify where the
row information will be placed on worksheet two, for example, B6 on worksheet
1 needs to populate on C24 of worksheet 2.

Thank you.