Hello Everyone :

I have been wrestling with this since yesterday but gotten nowhere,was hoping someone could show me the light

I have this workbook (attached here) in which I have the following 2 requirements :

1)if the user enters a value(which is a date) in column A : the value of '2' is automatically filled in column C


2)

a- if the user enters a positive number (+) in column D (eg : +100) : the value of 'DEP' is automatically filled in column 'H'

b- if the user enters a positive number (-) in column D (eg : -50) : the value of 'WD' is automatically filled in column 'H'.

Again as pointers would be much appreciated.

Many thanks

Attachment 2764

Attachment 2764