L
LuisE
I have sets of data in blocks of 3 continuous cells vertically arranged (top
to bottom) then each block (i.e A1:A3, B1:B3,.....) must go from letf to
right and when the data reaches column C it automatically goes down to the
next row and start over from left to right. Nie block of data (3 rows each
block) would look like this:
1 2 3
4 5 6
7 8 9
I need to shift the existing data as many blocks as indicated by the user
without loosing the original order.
Thanks in advance
to bottom) then each block (i.e A1:A3, B1:B3,.....) must go from letf to
right and when the data reaches column C it automatically goes down to the
next row and start over from left to right. Nie block of data (3 rows each
block) would look like this:
1 2 3
4 5 6
7 8 9
I need to shift the existing data as many blocks as indicated by the user
without loosing the original order.
Thanks in advance