itechxxiv
12-02-2005, 03:17 PM
I have a series of horizontal cells (7 IN ALL) that we use to track which
phases a document status is currently in.
List of phases a document will be tracked:
A. Not started =NS
B. in-progress =IP
C. under review=UR
D. reviewed =R
E. approved =A
F. on hold =OH
G. cancelled =C
We simply enter: "0"=NO or"1"=YES (Currently enter this manually and at
times find that a document status has to many "1"'s in a particular row.)
All phases will be populated with a "0" to begin with and the user will
enter/move "1" as the document progresses through each phase.
Example Excel Table:
Cell Range for columns Headers A1:G1
Cell Range for Rows A2:A4, B2:B4, C2:C4, D2;D4, E2:E4, F2:F4, G2:G4
+---+-----+-----+-----+-----+-----+-----+-----+
|...|..A..|..B..|..C..|..D..|..E..|..F..|..G..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.1.|..NS.|..IP.|..UR.|..R..|..A..|..OH.|..C..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.2.|..0..|..1..|..0..|..0..|..0..|..0..|..0..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.3.|..1..|..0..|..0..|..0..|..0..|..0..|..0..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.4.|.[1].|..0..|..0..|..0..|.[1].|..0..|..0..|<<avoid double entries
+---+-----+-----+-----+-----+-----+-----+-----+
<<The brackets are merely to highlight the duplicates>
To avoid the user entering duplicates ?1? in a single range of cells i.e. A4:G4. I want to incorporate a feature that upon entering ?1? in the adjacent cells. all the other cells are changed back to "0" zero.
For example: if the user enters a ?1? in B4 (In-progress) and then returns later to update the document phase and enters a ?1? in C4 (Under Review) cells A4, B4, D4, E4, F4, G4 will automatically change their cell value back to ?0? zero. And so on. So, regardless where you enter a ?1? all the other cells will change to ?0? zero. Preventing a user from entering multiple ?1??s
Thanks,
itechxxiv
phases a document status is currently in.
List of phases a document will be tracked:
A. Not started =NS
B. in-progress =IP
C. under review=UR
D. reviewed =R
E. approved =A
F. on hold =OH
G. cancelled =C
We simply enter: "0"=NO or"1"=YES (Currently enter this manually and at
times find that a document status has to many "1"'s in a particular row.)
All phases will be populated with a "0" to begin with and the user will
enter/move "1" as the document progresses through each phase.
Example Excel Table:
Cell Range for columns Headers A1:G1
Cell Range for Rows A2:A4, B2:B4, C2:C4, D2;D4, E2:E4, F2:F4, G2:G4
+---+-----+-----+-----+-----+-----+-----+-----+
|...|..A..|..B..|..C..|..D..|..E..|..F..|..G..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.1.|..NS.|..IP.|..UR.|..R..|..A..|..OH.|..C..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.2.|..0..|..1..|..0..|..0..|..0..|..0..|..0..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.3.|..1..|..0..|..0..|..0..|..0..|..0..|..0..|
+---+-----+-----+-----+-----+-----+-----+-----+
|.4.|.[1].|..0..|..0..|..0..|.[1].|..0..|..0..|<<avoid double entries
+---+-----+-----+-----+-----+-----+-----+-----+
<<The brackets are merely to highlight the duplicates>
To avoid the user entering duplicates ?1? in a single range of cells i.e. A4:G4. I want to incorporate a feature that upon entering ?1? in the adjacent cells. all the other cells are changed back to "0" zero.
For example: if the user enters a ?1? in B4 (In-progress) and then returns later to update the document phase and enters a ?1? in C4 (Under Review) cells A4, B4, D4, E4, F4, G4 will automatically change their cell value back to ?0? zero. And so on. So, regardless where you enter a ?1? all the other cells will change to ?0? zero. Preventing a user from entering multiple ?1??s
Thanks,
itechxxiv