Emoncada
01-30-2008, 09:12 AM
I have 5 status cells with a validation. I would a cell to tell me what the updated status is.
example
Cells
J11
J15
J19
J23
J27
If J27 = "" Then Go To J23
Else If J27 <> "" Then
If J27 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
If J23 = "" Then Go To J19
Else If J23 <> "" Then
If J23 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
If J19 = "" Then Go To J15
Else If J19 <> "" Then
If J19 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
And so on until J11 At some point it should find something and then when Saved it will look at Cell AA1 and know the latest update.
example
Cells
J11
J15
J19
J23
J27
If J27 = "" Then Go To J23
Else If J27 <> "" Then
If J27 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
If J23 = "" Then Go To J19
Else If J23 <> "" Then
If J23 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
If J19 = "" Then Go To J15
Else If J19 <> "" Then
If J19 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value
Else ("AA1") = "WIP"
And so on until J11 At some point it should find something and then when Saved it will look at Cell AA1 and know the latest update.