See the reply to your other post.

In article ,
halvy52 wrote:

Ok. I have something now. I did this on sheet 2. This only copies one cell
at a time. Is there a way to make it copy all of the cells using one
formula?