Hi,

I have a summary worksheet. On this summary worksheet i have my summary data to the left say cols A through U. Then at column Z (notice one column space between data and plots) i have graphs which are based off the data in cols A through U.

Here is what i am trying to do. I am copying data from another workbook and trying to paste it into column V of my summary sheet but i want to shift all the other cols over so that the graphs still have "this one column" separation between my data and graphs. Here is the code i used:

Please Login or Register  to view this content.
But it does not seem to work. Afgter i copy and paste the data into column V the graphs (which once had a one column separation) butt-up agaist the data.......ie....the graphs did not shift over.

Any ideas why?