Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one sheet to another
Thanks Ossie, that works nicely.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Auto copy cell data from source sheet to another wrkbook sheet | Excel Programming | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
Copy data from sheet 1 to sheet 2 based on day/date | Excel Programming |