Auto populate worksheets

Originally Posted by ajryan88

I think I understand. Your formula above should be inserted into cell C1 on sheet 2, and should look like this:

Formula:

=IF(Sheet1!A1=Sheet1!B1,Sheet1!C1,"")

Explanation:
If the value of A1 and B1 on Sheet1 are identical, then the formula will return the value of C1 on Sheet1, otherwise it will return an empty string.

I hope I have understood you correctly. If not please let me know. If this is a misunderstanding, then again I will suggest that you please upload a workbook containing a sample of your data and an explanation of the outcome(s) that you are trying to achieve.

Thanks

That is my understanding of the posters query, without data makes it harder to show a true representation.