moving blocks of date from 1 column to several columns in block order

[jsgraver]

hi everyone
can anyone give me a clue as to automate moving blocks of numbers from one column into several columns other than just going down the column and cutting and pasting
o
o


o
o
o
o

o

needs to be column 1
o
o
column2
0
0
0
0
column 3


o
Any help would be greatly appreciated
thanks

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[jsgraver]

Thank you very much !!!!!!
I will try it out when I get home

[jsgraver]

Hi Mr Sixthsense
Could not wait to try this !!!!!!
Good news it works
Bad news it needs to keep the original positions ie not move to the top of the columns
Can you help as I am not VBA savvy
Thanks