I want to save a table or rows(timesheet) with value to a new sheet daily but in same sheet every day .RED one
uj V10.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |||
3 | Date | DATA_WIPE | INSPECTION | ||||||||||||
4 | ##### | Uph | Hour | Pcs | Done | Diff | % | Pass | Fail | Sams | Other | ||||
5 | DATAWIPE | 21 | 3.25 | 68 | 70 | 2 | 8.33 | ||||||||
6 | LPN | 270 | 1.50 | 405 | 410 | 5 | 1.85 | ||||||||
7 | SALINSP | 32 | 2.00 | 64 | 65 | 1 | 3.12 | ||||||||
8 | GSXCHCK | 78 | 0.00 | 0 | 0 | 0 | 0.00 | ||||||||
9 | PRODEF | 50 | 0.00 | 0 | 0 | 0 | 0.00 | ||||||||
10 | RETINSP | 4.1 | 0.00 | 0 | 0 | 0 | 0.00 | ||||||||
11 | REVREC | 26.1 | 0.00 | 0 | 0 | 0 | 0.00 | ||||||||
12 | DEFPUT | 89 | 0.00 | 0 | 0 | 0 | 0.00 | ||||||||
13 | HYGIENE | 0 | 0.00 | 0 | 0 | 0 | 0 | 0 | |||||||
14 | SELECT | 0 | 0.00 | 0 | 0 | 0 | |||||||||
Jobs |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
AB14 | Expression | =$AB$14=0 | text | NO |
AC13 | Expression | =$AC$13=0 | text | NO |
AB13 | Expression | =$AB$13=0 | text | NO |
AA13 | Expression | =$AA$13=0 | text | NO |
Z14 | Expression | =$Z$14:$AA$14=0 | text | NO |
Z13 | Expression | =$Z$13=0 | text | NO |
X5 | Expression | =$X$5<0 | text | NO |
X9 | Expression | =$X$9<0 | text | NO |
X13 | Expression | =$X$13<0 | text | NO |
X12 | Expression | =$X$12<0 | text | NO |
X11 | Expression | =$X$11<0 | text | NO |
X10 | Expression | =$X$10<0 | text | NO |
X8 | Expression | =$X$8<0 | text | NO |
X6 | Expression | =$X$6<0 | text | NO |
X7 | Expression | =$X$7<0 | text | NO |
X5:X14 | Cell Value | >=20 | text | NO |