I have copied some data over using copy and paste special and trying to
find a easy way to continue on sheet i.e I have on sheet 1 cell a2
copied from sheet 2 cell a2 and sheet 1 cell b2 copied from sheet 2
cell e2. what im trying to do is to be able to copy the copy and paste
special formula on. Therefore sheet 1 a3 is from sheet 2 a3 and sheet 1
b3 is from sheet 2 cell e3. I want to be able to copy the columns down
so I dont have to copy and paste special every cell. Can anyone help?




--
tweacle