Pasting formulas based on cell color: Formula? or Macro?

Hello All
I am working on a rather large spreadsheet (66 K Rows) and have attached an abbreviated version for this forums expertise

Is it possible to paste a formula into a column based on a corresponding cell that is filled in with a color and text that resides in that cell OR just simply the text that resides in the cell?

Hopefully I can explain this via the spreadsheet:

I am looking to copy the formulas that reside in Cells F5 through AK5 into the corresponding column F cells that have text in column A

Thanks in advance
Ron

Hello Ford and ZeroCool

Thanks for helping. Let's see if I cant communicate a bit better

In the spreadsheet, you will notice different formulas in each cell from F5 to AK5. These are necessary due to the insurances I have to work with and how I need to report these out.

What I am trying to do is this

Cell A11 has text inserted( name ). I need my formulas from F5, G5, H5 etc to show up in every corresponding column F11, G11, H11 etc, F16,G16,H16 and so on) that has text in Column A. I started to do this manually as you can see, but there is no way I can do this for 60K rows of data , so I was hoping there was a formula, format, macro , anything to help with this nightmare ( ha ha)

Thanks so much
Ron

Hello Ford and ZeroCool

Thanks for helping. Let's see if I cant communicate a bit better

In the spreadsheet, you will notice different formulas in each cell from F5 to AK5. These are necessary due to the insurances I have to work with and how I need to report these out.

What I am trying to do is this

Cell A11 has text inserted( name ). I need my formulas from F5, G5, H5 etc to show up in every corresponding column F11, G11, H11 etc, F16,G16,H16 and so on) that has text in Column A. I started to do this manually as you can see, but there is no way I can do this for 60K rows of data , so I was hoping there was a formula, format, macro , anything to help with this nightmare ( ha ha)

Thanks so much
Ron

Thank you Ford !

I appreciate your time Ford ! Someone was able to help with a Macro, but it wont seem to work when I copy and paste the correct names in Column A..Hopefully we can get there

Sorry about that ! I just assumed I should start another thread in the Macro Section. My apologies