'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:
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.
Bookmarks