| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shif cells to the right and down within limits
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 indicated starting from left to right and then when column C is reched downbelow to the nex available row, something like this 123 456 789 would look like this if shifted two blocks 1 234 567 89 Thanks in advance ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Please.....numbers reaching limits and cells changing colour | Excel Worksheet Functions | |||
| how do I round hours worked to the next half hour with a 24hr shif | Excel Worksheet Functions | |||
| Row Limits | Excel Worksheet Functions | |||
| Limits | Excel Discussion (Misc queries) | |||
| Using UsedRange as limits in a For Each loop but for cells on another sheet ? | Excel Programming | |||
Threaded Mode
