Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows
Hello,
I am trying to figure out if it is possible to code a VBA macro (and if so how to do it) to take the first 7 rows of data from Column A and move it to the first row of Columns B,C,D,E,F,G,H and then proceed to the next 7 rows in Column A and move the data to the next available rows in B,C,D,E,F,G,H. Example: A1 move to B1 A2 move to C1 A3 move to D1 A4 move to E1 A5 move to F1 A6 move to G1 A7 move to H1 A8 move to B2 A9 move to C2 A10 move to D2 A11 move to E2 A12 move to F2 A13 move to G2 A14 move to H2 A15 move to B3 A16 move to C3 A17 move to D3 A18 move to E3 A19 move to F3 A20 move to G3 A21 move to H3 and so on until there is no more data in Column A. Any help would be greatly appreciated. Thanks, DIDS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from first 7 rows from one column A into multiple Columns then the next 7 rows
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from first 7 rows from one column A into multipleColumns then the next 7 rows
Hi Claus,
That worked perfect. Thank you very much for your help. Thanks, DIDS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select rows of data & move to new column | Excel Programming | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
Move Column data to rows | Excel Programming | |||
Need a macro to move data from column into rows | Excel Programming | |||
Move data from different columns into one column, but different rows. | Excel Programming |