Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have sets of data in blocks of three vertical cells (A1:A3, B1:B3, C1:C3,
A4:A6, B4:B6...................). I need to shift them as many blocks as the user indicates starting from left to right and then when column C is reached down below to the next available row, something like this Original order A1: Red B1: Blue C1: Pink A2: Red B2: Blue C2: Pink A3: Red B3: Blue C3: Pink A4: Black B1: White C4: Yellow A5: Black B1: White C5: Yellow A6: Black B1: White C6: Yellow If they choose to shift 1 (block of data) it'll look like this B1: Red C1: Blue B2: Red C2: Blue B3: Red C3: Blue A4: Pink B4: Black C4: White A5: Pink B5: Black C5: White A6: Pink B6: Black C6: White A7: Yellow A8: Yellow A9: Yellow Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SHIFT G | Excel Discussion (Misc queries) | |||
Shift-JIS to UTF-8 | Excel Programming | |||
Shift Key | Excel Programming | |||
What's This? help (Shift-F1) | Excel Programming | |||
How 2 use right shift "<<" and left shift "" operator in excel? | Excel Programming |