Hi.

I use 4 different formulas in range M2:P2, for getting data. ALL formulas in front of these have this condition.

=IF(A2<>"","MY FORMULA"."")

The Sheet in full action, will have some thousands of rows(I don't know how many....).

So copying down range M2:P2 for some thousands rows makes my pc slow.

My idea is to use a code that will look continiously in column A and if there are data in A, copy my formulas until this row.

Example: Range A2:A10 has data. Then Range M2:P10, FILL WITH MY FORMULAS.

A2:A500 are full? Then M2:P2 must fill with my formulas...and so on.

Any ideas?

Thanks in advance.