for untested air code that was pretty spectacular
I've grown far too addicted to looping through ranges, so I do it in my sleep. Definitely not something I can brag about. LOL
So as you're looping through column A, you want to copy just specific cells? Just use Offsets. Example, let's say you only want to copy G.
myrange.entirerow.copy ws2.range("A" & ws2.rows.count).end(xlup).offset(1,0)
myrange.offset(0,6).copy ws2.range("A" & ws2.rows.count).end(xlup).offset(1,0)
At some point all this use of Offset to determine where the next blank row is in the Destination
sheet may become problematic IF you don't fully understand and make sure it corresponds to where you do or don't have blank data.
Because the ws2.range("A" & ws2.rows.count).end(xlup).offset(1,0)
is like goint Ctrl+UpArrow from bottom of sheet to closest-up cell with data. If you have data on that destination sheet on a "bottom row" in B, C, D, E but not A, then this method will go up even higher, until it finds data in A.
In other words you have to be aware of this, hope that explains