Copy data from once worksheet to another using formula

[Maureen]

I am trying to create a formula in which I am able to copy data from one
worksheet to a cell of a different worksheet in the SAME workbook based on
specific criteria.

For example, if cell A2 on Worksheet A contains item data, I want to copy
that exact data to Worksheet B cell D50. I need to use a formula as there
will be additional criteria added later on.

How should I proceed?

 

[Sheeloo]

Use something like this in D50 of Worksheet B
=IF('WorkSheet A'!A2>100,'WorkSheet A'!A2,"Not > 100")

 

[Maureen]

Thanks I will give i a try

Use something like this in D50 of Worksheet B
=IF('WorkSheet A'!A2>100,'WorkSheet A'!A2,"Not > 100")