Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one sheet to another
Start with a WB with two existing sheets: Sh1, Sh2
Sh2 contains a lot of permanent records. Sh1 contains temporary records for transfer to Sh2. Sh1 has a header row and 7 columns (A-G) and variable number of records. I want to copy all records on Sh1 then paste on Sh2 below existing records, but, for each record Sh1 Column "A" goes in Sh2 Column "E" Sh1 "B" goes in Sh2 "C" Sh1 "C" goes in Sh2 "K" etc. I'm thinking copy Sh1 into a Dynamic Array and then copy to Sh2 element by element? |
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) | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
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 |