Hi would like to find out, what should the formula be like if i wanted to
pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of
worksheet A is true. The formula i have so far looks like this.

"=IF('A'!F10="X", "'B'!B3='A'!B10'", "")

However, the result i get if 'A'!F10="X" is B'!B3='A'!B10'.

The alternative to that situation would be to change the formule to

"=IF('A'!F10="X", '"B'!B3='A'!B10"', "")

However, the result would an error with B10"' portion.

Any ideas on where to go from here?

Thanks a million in advance!