-
Call macro pending on value
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules