(Hideously frustrated as it took me 15 mins to write my problem and the boards logged me out in the meantime. I am now having to rewrite from scratch :censored: )
I have been asked to link two worksheets in the same workbook. I need to copy across data if a column says one thing and a blank line if it says another. I am using the formula =IF('worksheetA'!A31="s",'worksheet A'!B31,"-") i.e. if A31 in worksheet A has "s" in it, print the contents of B31 into the cell in worksheet B. If it is not an "s", then print "-" in worksheet B.
However, if I add in a line into worksheet A (i.e. Insert a line below row 31: row 32), the formula in worksheet B jumps from row 31 to row 33 and does not add in row 32. As lines are being added into worksheet A all the time, how can I get the formula in worksheet B to recognise that a row has been added into worksheet A? I do not want to click and drag the formula through worksheet B each time worksheet A is updated as I have highlighting through worksheet B which I would have to redo each time (and worksheet A is updated several times a day)
All help will be appreciated!!