Need a macro to introduce multiple conditions. IF

[lu fim]

'm having trouble on building a multiple condition code. Here's what i need to do:

these conditions must run down trough a list.

When column H already have a date, do nothing to column H;
When AW (date column s) is empty do nothing to column H;
When column J is written "Date closed" do nothing to column H;
when column I is written "Control", cell in column H egal to cell in column AW
When column Z is written "Transport to STK/FORN" insert date 2 days in front of today in column H
If none of the above cell in H = cell in AW

The bottom conditions cannot overwrigh the top conditions.

code:

Please Login or Register  to view this content.

I tried to lock the cells in the first condition so the conditions below won't overwrite these first conditions.

I am sorry for the bad english.

[JBeaucaire]

This macro seems to do the steps you've outlined:

Please Login or Register  to view this content.

[lu fim]

ElseIf UCase(Range("Z" & rw).Value) = "TRANSPORT TO STK/FORN" Then
Range("H" & rw).Value = Date + 2


This condition, it didnt insert the right date. It copied from column AW.

[JBeaucaire]

That's not possible, based on that code. I'm going to guess it actually skipped that line section copied from AW.

[lu fim]

isnt there an "DateAdd" function? Saw some tips on google, here one of the responces:

http://excel-macro.tutorialhorizon.c...tions-dateadd/

I tryed this on the conde:

ElseIf UCase(Range("Z" & rw).Value) = "TRANSPORT TO STK/FORN" Then
Range("H" & rw).Value = DateAdd("d", 2, Date)
Else
Range("H" & rw).Value = Range("AW" & rw).Value

but allso no succes =/

[JBeaucaire]

The DateADD thing isn't needed. Date+2 does the job.

Working blind, I'm going to guess that line of code is being skipped and it's the NEXT section that is updating based on the AW value.

Something in column Z is not what it appears to be. Hidden spaces or something, perhaps?

[lu fim]

I looked for hidden columns, but there was none. I copied the value i wanted of Z to the code so i wouldnt miss any spaces or misspelling, but still it brings me the value of AW instead of date+2.