Posts by PatNecom

    Hello and Welcome to the Forum

    Attaching a sample file would make everything easier ... for everybody :smile:

    Hi Carim

    Thanks for your answer. I havent answer cause i was quite busy but thanks for chasing. The way I have fixed it is with the following code: Probably not the most efficient but it works for my needs

    As the step 2 copy data into a table formulas get copied into the last row of the table so no need to have code that copies the values until the last row with data.

    Anyway Carim, thanks a lot for your help!!!