Need to know if you want the data copied to the corresponding columns on
sheet2 or if you want it copied to the first 6 columns.


--
Regards,

OssieMac


"Slim Slender" wrote:

Here's my challenge.
Copy the contents of cells B3, D3, G3, B6, D6, G6 on Sheet1 to the
first empty row on Sheet2, then,
if there is something in B7, D7, G7, copy B3, D3, G3, B7, D7, G7 to
the next empty row on Sheet 2, and
if there is something in B8, D8, G8, copy B3, D3, G3, B8, D8, G8, etc.
.