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: