How to create macro with keystrokes to be used anywhere w/o a range

Can you please solve a BIG headache & mystery for me?

I am trying to create a macro to replicate keystrokes so that I can use it anywhere within the spreadsheet. I don't know how to replicate keystrokes without Excel using the exact range of cells where I am located and jumping back to that spot. I want it to be "movable" to other parts of the spreadsheet.

Feel free to use a different example in your solution, as long as it explains how to use non-relative keystrokes that can be used anywhere in the spreadsheet (i.e., press a particular key, or set of keys, a certain number of times).

Example: create a formula by:
1) On the current selected cell (F559), type the = sign (to start a new formula)
2) Press UpArrow key twice (to select the cell two up from where my formula is: F557)
3) Press F4 key twice (to toggle & get the F$557 absolute reference I want)
4) Press * (asterisk symbol to multiply)
5) Press LeftArrow key once (to select the adjacent cell one to the left)
6) Press F4 key three times (to toggle & get the $E559 absolute reference I want)
7) Press Ctrl+Enter (to save the formula without moving from the selected cell)
8) Press Ctrl+C (to copy formula in selected cell)
9) Press Ctrl+Shift+DownArrow (to select the rest of the range below)
10) Hold Shift and press RightArrow key two times (to select cells in two more rows to the right)
11) Press Enter (to paste the formula in selected cell range)

The idea is that I can use the same relative movements based on the selected cell I start with, since this is a section of about 10 lines that gets copied/pasted as new rows with different data in the top cells of columns F, G and H.

Thanks a million for your help!!

Post the recorded macro.