Copy paste visible on same sheet

[Jay]

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

 

[Don Guillett]

a bit more explanation might be helpful.