Did you try my shot at this in the other branch ? Thought it returned results
similar to what you're re-describing below.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GARY" wrote:
Ideally, after moving the data in A1's related cells, all of A1's
related cells should be in row 1.
Ideally, after moving the data in A7's related cells, all of A7's
related cells should be in row 7.

I do NOT want to clear the cells in rows 2 thru 6.
I want to find cells on these rows that contain data (so I can move
these cells, too).

Gary