OK, that is not what I thought was happening at all. I think I am thoroughly confused by it all.
That being said, I am a very visual person, and verbose explanations usually lose me fairly quickly.
Can we take a bit of a different approach? Let's try this:
Walk me through the first few tests, giving me explicit instructions, i.e.
- Tell me that exact range address of the
first test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Tell me that exact range address of the
second test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Go through a few more iterations like this (like 4 or 5 in total)
If I see if from that standpoint, I will hopefully be able to see the pattern to use.