Here is a layout of what I am dealing with:
A B C D E
1 a b c d e
2 2 4 6 8 10
3 2 4 6 8 10
4 4 8 12 16 20
5 1 1 6 8 10
6 1 1 6 8 10

Row 1 is a fix row and row 4 is the total for the column. Row 5 & 6 is data
from external source (ACCESS). Column a & b are values and c,d,&e are values
taken from c5, d5, etc. I need a way to move columns forward w/o loosing the
formulas. For example, delete a2 & a3 and copy and paste b2 &3, c2 & 3, d2
&3, and e2 &3 one space to the left but keep all the formulas in tack.
Any advice would be appreaciated. Thanks, Greg