Clear cells in workbook while leaving Formulas and headers intact

[Raedars]

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.

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>

 

[JoeMo]

Do the cells in red font hold constants and all the others (except the headers) formulas? Are the headers all in the same row? If yes, which row is that?

 

[bbotzong]

Here's a trick I learned. Put a conditional formula in the cells you want to routinely clear. After you highlight the values you will clear, click the Home tab, click Conditional Formatting drop down, then New Rule, then OK. That will apply a conditional formatting that does nothing to the formatting.

When you're ready to clear those cells, click the Home tab, in the Editing Group, click the Find & Select drop-down, then click Go To Special. In the dialog box that opens, select Conditional Formatting. All of the cells you want to clear are now selected (highlighted). Click the Clear drop down in the same group and select Clear Content. That should do it. If you add new employee rows, make sure to select a row that contains an existing employee, <ctrl>+<c> to copy, then select the row of the new employee and Paste Special Formats. That way, their data will contain the conditional formatting and will be selected with the Go To Special trick.