Condition Paste Formula in Column N based on Column A

Hello

I am wanting to paste formula from N1 till N X (X = varaiable row) where X reliant on Column A Row X. If Column A Row X has character "=====" it should paste N1 Formula all the way down till N Row X which is equal to A Row X containing "=====" .

I might be sounding complicated over here but it is a simple equation.. I have tried to approach this in the capacity i could by condition if Column A row x is blank delete the row.

Please Login or Register  to view this content.

but Im finding this approach to be much lengthy process n i am sure someone has a better code up their sleve on this..


If anyone could help

regards

Tek9step

It's not clear if "====" appears in the last row of data or not, if it does you can simplify somewhat to:

Please Login or Register  to view this content.