Add text to cell relative to location of text in another cell

I am trying to add a command in a macro that finds the text "Sum Total" in column A and goes up 5 rows from where it is and adds text in that row. So if "Sum Total" is in A50, I want it to go back to A45 and type a certain text, then B45, C45... I also want to go up 4 rows and add text, then up 3 rows... but I am hoping that once someone can get me started, I can take it from there.
Thanks.

thanks MarvinP