Copy formula in sheet to all rows containing info in Cell A

[Elmarie_Potgieter]

I am looking for someone to help me with a macro where I can copy a row of formulas in a sheet and paste it into the same sheet where Cell A contain information.

I've attached the file as an example.

On the "NW" Tab, the formulas in the Yellow cells H1:J1 should be copied and pasted in the cells from H8 untill there is no more information in Cell A. Pasting of this formula should always start at Cell H8.

On the "Result" Tab is the desire result.

This list can have as many as 5000 entries and as little as 8 entries a month.

Thank you.

[:) Sixthsense :)]

untill there is no more information in Cell A

Unable to understand what you are trying to say with the above line

[Trebor76]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[Elmarie_Potgieter]

If one month there is 110 lines with information (from A8 to A118), the formula should stop at the 110th line (H118). If the next month there is only 50 lines with information (from A8 to A58), the formula should stop at the 50th line (H58) with information. The lines of information varies every month.

[Elmarie_Potgieter]

Thank you Robert, this macro works 100%.

[Trebor76]

Thank you Robert, this macro works 100%.

You're welcome