I copied from the Internet data into one column. I'd like to automatically
move one cell with data one column across (to the right) and two lines up so
it sits next to another line with data.

To do this I would have to write a macro, selecting and shifting 2oo times.
Is there a way in a macro to move down 11 lines and right 1 column rather
then every time selecting a specific cell and move it?

activecell.copy activecell.offset(11,1)
Will copy the active cell down 11 rows and one column to the right
to actually move use CUT instead of COPY

But, tell us what you are trying to do. There may be a better way.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Felix" <(E-Mail Removed)> wrote in message
news:458F48DC-F388-4F66-829A-(E-Mail Removed)...
>I copied from the Internet data into one column. I'd like to automatically
> move one cell with data one column across (to the right) and two lines up
> so
> it sits next to another line with data.
>
> To do this I would have to write a macro, selecting and shifting 2oo
> times.
> Is there a way in a macro to move down 11 lines and right 1 column rather
> then every time selecting a specific cell and move it?
>