Copy data from one sheet to another
 

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.

Copy data from one sheet to another
 

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.
.

Copy data from one sheet to another
 

On Feb 17, 5:46*am, OssieMac
wrote:
Need to know if you want thedatacopied 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.
Copythe 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,copyB3, D3, G3, B7, D7, G7 to
the next empty row onSheet2, and
if there is something in B8, D8, G8,copyB3, D3, G3, B8, D8, G8, etc.
.- Hide quoted text -

- Show quoted text -

Copy into the first 6 columns to create record in a database.
Where it says etc means there are 5 more examples for a total of 8,
and not an indefinite number. Note that B3, D3, and G3 are repeated.
Thanks

Copy data from one sheet to another
 

Thanks Ossie, that works nicely.