Hi all
I have a sheet which downloads data onto it. This data is split into logical columns eg 'Price'
However this column will not always be the same and some rows dont contain a value for price.
Can anyone help me to create a procedure that identifies all values for price and replaces them with a generic value eg 100 goes to ?100
thanks in advance