Apologies for the previous incorrect titling
Hi all, I have really 2 questions to ask please.
Firstly, I have 3 sheets. Sheet 2 must copy certain data on sheet 1 when inputting to sheet 1. I have extended the formula in sheet 2 but it is displaying a series of 0's where a cell on sheet 1 is empty. I have managed to get sheet 2 to refer to completed cells on sheet 1, but not if the cell is empty. Basically i do not want the zeros.
Secondly, i want to enter certain data on sheet 3, if the same data is on sheet 2 then i would like the row containg that data highlighting.
Any help or tips would be appreciated, Thanks
Mike
Bookmarks