I currently use Excel spreadsheet to enter time sheets before I send them off to be processed. I currently use the current week time sheet (adding and deleting employees as needed) - and then after I enter the weekly time I save as the current week but use SAVE as new workbook and clear cells indivudually as required to use as a blank template for the following week.
Is there a way to Mass clear only some spreadsheet cells while leaving the cells with Pertinent Employee info along with formulas for calculations alone?
I tried to write a code to clear cell contents in specific ranges , however since the number of rows in my worksheet change constantly - i am deleting rows that I need and not deleting those that I dont.
Sample below :
i require all the cells in BLACK to remain unchanged and the cells in RED to be cleared. Is this possible? is there a code I would write to make this happen?
Note: Protecting sheet / cells seems to be ineffective so far.
<colgroup><col><col><col><col><col><col><col><col><col span="21"><col span="3"><col><col></colgroup><tbody>
</tbody>
Is there a way to Mass clear only some spreadsheet cells while leaving the cells with Pertinent Employee info along with formulas for calculations alone?
I tried to write a code to clear cell contents in specific ranges , however since the number of rows in my worksheet change constantly - i am deleting rows that I need and not deleting those that I dont.
Sample below :
i require all the cells in BLACK to remain unchanged and the cells in RED to be cleared. Is this possible? is there a code I would write to make this happen?
Note: Protecting sheet / cells seems to be ineffective so far.
EE | EMPLOYEE NAME | PAY RATE | LAC CODE | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | ER | EOT | EDT | TOTAL | $$ | ||||
No# | C/I | LAST | FIRST | & UNION | & LEVEL | JOB # | DIM CODE | 1 | 1.5 | 2 | 1 | 1.5 | 2 | 1 | 1.5 | 2 | 1 | 1.5 | 2 | 1 | 1.5 | 2 | 1 | 1.5 | 2 | 1 | 1.5 | 2 | ER-1 | EOT - 1.5 | EDT-2 | HOURS | |
B1314 | I | BISHOP | FRANK | $ 30.00 | L1034 | BISHOP | EE- Sub T | 0.00 | 0.00 | 10.00 | 0.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 9.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10.00 | 0.00 | 17.50 | 10.00 | 20.00 | 47.50 | LOA |
51303949 | NTX-LOA | 10.00 | 10.00 | 10.00 | $585.00 | ||||||||||||||||||||||||||||
61307451 | NTX-LOA | 8.00 | 9.50 | $341.25 | |||||||||||||||||||||||||||||
- | NTX-LOA | $0.00 | |||||||||||||||||||||||||||||||
- | NTX-LOA | $0.00 | |||||||||||||||||||||||||||||||
- | NTX-LOA | $0.00 | |||||||||||||||||||||||||||||||
TRAVEL | JM | GEN DIM | |||||||||||||||||||||||||||||||
WK TOTAL HRS: | 47.50 | INDUSTRIAL | 51303949 | PLC | 9.50 | 9.50 | 0.00 | 0.00 | 19.00 | 19.00 | |||||||||||||||||||||||
51303949 | PLC-SFJ | 0.50 | 0.50 | 0.00 | 0.00 | 1.00 | 1.00 | ||||||||||||||||||||||||||
61307451 | PLC-X | 8.00 | 9.50 | 10.00 | 17.50 | 10.00 | 0.00 | 27.50 | |||||||||||||||||||||||||
0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||||||||
0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||||||||
0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||||||||
0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||||||||
0.00 | 0.00 | 0.00 | 0.00 |
<colgroup><col><col><col><col><col><col><col><col><col span="21"><col span="3"><col><col></colgroup><tbody>
</tbody>