LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Shift down and then to the right

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SHIFT G Palle Excel Discussion (Misc queries) 2 March 26th 08 11:19 PM
Shift-JIS to UTF-8 dolsen[_2_] Excel Programming 0 July 5th 07 09:01 PM
Shift Key pan65 Excel Programming 1 June 1st 07 10:33 AM
What's This? help (Shift-F1) Martin Excel Programming 0 December 11th 06 11:54 AM
How 2 use right shift "<<" and left shift "" operator in excel? v-2ajpau Excel Programming 2 December 28th 05 01:33 PM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"