Auto populate worksheets

Hi,
I am trying to populate worksheet 2, after criteria "x" is met on Worksheet1.
I have tried an IF statement, but I am not sure that is the appropriate method.
This is general info, such as name address, etc. no calculations.
Any help would be greatly appreciated.

I would be happy to take a look if you could please upload your workbook

Here is the file, Thank You in advance.

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

Something like that, if not give us a sample please.

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

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.

I uploaded a workbook----more than once.

Thanks

Here is a short version of what I am trying to do.

Thank you

Sorry, I should have updated you. I'm looking into it as I reply to this Sorry for the lack of communication

Have setup this sheet for you as I think your wanting it to display on secondary sheets

Using an extra field for each additional sheet (on sheet1, col N is for HR, Col O is for ER)
formula in those cells

Placed this in Col N
=K2&COUNTIF($K$2:K2,K2) <-- HR cell on sheet1

On HR sheet, place this in A2 and copy across and down as required.
=IFERROR(INDEX(Sheet1!$A$1:$N$6000,MATCH("x"&ROW(A1),Sheet1!$O$1:$O$6000,0),MATCH(A$1,Sheet1!$A$1:$N$1,0)),"")

Thank you, I think this will work. I really appreciate your help.

Hi Karen,

Just out of curiosity, which solution did you use?

Also, please don't forget to mark this thread as solved and say thanks to anyone who helped you by clicking on the * next to their post

Hi,
I used the AYdata, but also downloaded the example you posted. Thank you both for taking the time to help out.