Hey guys i spent some time learning the index array and it looks good, but for some reason i'm not able to get the whole column copied over. It's only the first cell. I've attached my program as well as the sheets to help. The two images show the original sheet i want to copy from, and the new sheet with the results. As you can see it just copies the first cell into the entire column.
