Hello, I am trying to create the formula for copying text in one cell from sheet2 onto another cell on sheet1. I can come up with a solution if the data is on one sheet but because I'm working on two separate sheets the formula falls over. My attempt so far =IF('Sheet2'!B2="",F2,'Sheet2'!B2), apologies if the solution is simple, I'm still learning. Many thanks
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!