Could somebody please help me.
I have a workbook comprising two worksheets showing a product list. I have virtually achieved what I need apart from one part.
I have one column which is the result of an "IF" function, it shows all "0" apart from one description which is derived from another column. I basically need to get this one text cell, which can be anywhere in this column, to display in one cell on the other worksheet.
I am sure there must be an easy solution, but I am banging my head against the wall at the moment, so any help would be truly appreciated

TIA