Madiya

Well this works somewhat it actually copies over the formulas in the
cells not just the numbers that are in the cells a lot of #REF! in the
cells on Sheet 1A.

Do you have an idea how to fix this?

Very close though, thanks for your input..

By the way for your question there will never be more than 10 rows
needed on sheet 1A..


Regards
Pano