Hi, I have a range of cells (3 x 6) the 1st cell is

O7 and has the following formula in it =Sheet!A3 then

O8 is blank

O9 and has the following formula in it =Sheet!A6

O10 is blank

O11 and has the following formula in it =Sheet!A9

O12 is blank

P7 and has the following formula in it =Sheet!A4 then

P8 is blank

P9 and has the following formula in it =Sheet!A7

P10 is blank

P11 and has the following formula in it =Sheet!A10

P12 is blank

Q7 and has the following formula in it =Sheet!A5 then

Q8 is blank

Q9 and has the following formula in it =Sheet!A8

Q10 is blank

Q11 and has the following formula in it =Sheet!A11

Q12 is blank

These cells all fall under 1 date is there a quick way I can copy then across to the next date? As whenI do try and copy them across instead of the first formula in cell R7 being B3 its coming up as AC3,AC6,AC9 instead of what I need which would be A3,A6,A9

Any ideas?? Thanks…

O7 and has the following formula in it =Sheet!A3 then

O8 is blank

O9 and has the following formula in it =Sheet!A6

O10 is blank

O11 and has the following formula in it =Sheet!A9

O12 is blank

P7 and has the following formula in it =Sheet!A4 then

P8 is blank

P9 and has the following formula in it =Sheet!A7

P10 is blank

P11 and has the following formula in it =Sheet!A10

P12 is blank

Q7 and has the following formula in it =Sheet!A5 then

Q8 is blank

Q9 and has the following formula in it =Sheet!A8

Q10 is blank

Q11 and has the following formula in it =Sheet!A11

Q12 is blank

These cells all fall under 1 date is there a quick way I can copy then across to the next date? As whenI do try and copy them across instead of the first formula in cell R7 being B3 its coming up as AC3,AC6,AC9 instead of what I need which would be A3,A6,A9

Any ideas?? Thanks…

Last edited: