Copy Formula down the column based on data in the next column

Hi.

I have a spreadsheet that I have automated much of, but now I am trying to copy a formula down from Q2 until the data ends in column A as there are some gaps in the column next to them.

Here is the code that I am currently working with;

Please Login or Register  to view this content.

Any help on this would be great.

Many Thanks

Try this:

Please Login or Register  to view this content.

Thats Great worked perfect...

Many Thanks
Karl