formula

[HOWARD23]

need a formula
if c7 on sheet1 = x
the data from b7 and d7 onsheet1 needs to transfer to a1 and b1 on sheet2

[Bob Phillips]

Try

Sheet2!A1: =IF(Sheet1!C7="x",Sheet1!B7,"")
Sheet2!B1: =IF(Sheet1!C7="x",Sheet1!D7,"")

[Paul]

Hi Howard, welcome to the forum.

Please take a moment to read the forum rules (link in my signature below) and then amend your thread title to something descriptive of your problem. Once you have done this, please send me a PM and I will remove this request.

Thank you.