I have a function that refers to a cell on a different worksheet, say A1, and
in the adjacent cell I have another function that refers to another cell on
the other worksheet, but in a different block, say AA1, for example. I want
to select both cells and drag them across to reference B1 and AB1, C1 and
AC1, etc in adjacent cells, but when I do it yields C1 and AC1, E1 and AE1,
etc, effectively skipping every other column in each block. I can see why its
doing it, and I can get around it with some cutting, pasting and faffing, but
I was wondering if anyone knew of a work around???