Hi,

I have a largish (3500 rows of data) with alternate formula / data
sections.

Each week I need to move the data across one cell to the left. The data
can be sorted so only the required cells are visible, which I can in
turn copy (using special/visible). But I cannot seem to get it to paste
one row along as I get a multiple selection error.

The other cells do not need to move along.
c1 c2 c3
R1 Data Data Data
R2 Form Form Form
R3 Form Form Form
R4 Data Data Data
R5 Data Data Data
R6 Form Form Form
R7 Data Data Data
R8 Data Data Data


Columns 2 and three get copied across to c1 (overwriting)

Thanks in advance and hope its clear

J

a bit more explanation might be helpful.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Jay" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I have a largish (3500 rows of data) with alternate formula / data
> sections.
>
> Each week I need to move the data across one cell to the left. The data
> can be sorted so only the required cells are visible, which I can in
> turn copy (using special/visible). But I cannot seem to get it to paste
> one row along as I get a multiple selection error.
>
> The other cells do not need to move along.
> c1 c2 c3
> R1 Data Data Data
> R2 Form Form Form
> R3 Form Form Form
> R4 Data Data Data
> R5 Data Data Data
> R6 Form Form Form
> R7 Data Data Data
> R8 Data Data Data
>
>
> Columns 2 and three get copied across to c1 (overwriting)
>
> Thanks in advance and hope its clear
>
> J
>