Filling Empty Cells With Value VBA in ever changing file

I am trying to make a program that will run on an exiting spreadsheet generated by someone else. This sheet will change in number of items size every time its generated but I know that the first 5 rows will be constant throughout. I have figured out a way of doing the process by hand operations in excel but I haven't been able to produce any vba code that could do this automatically.

The attached sample file file shows a starting point for the file, the end result and the excel calculations needed to get there.

Does this help?

Sub penbeacho()
With Range("E5:E" & Range("C" & Rows.Count).End(3).Row).SpecialCells(4)
    .Font.ColorIndex = 3
    .Font.Bold = True
    .Value = "Operating"
End With
End Sub

This Worked Great, Thank you so much!!

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. Refer too link for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html