Cell entry + data validation

Hi,

I'm using the following code, so that if someone enters data into the range, the formula is entered into column 'H', but only on the same row as the data is entered. Is there a way to adapt this so that if someone enters data into the range, data valdation is added to the cell on the same row in column 'F'

Please Login or Register  to view this content.

thanks