G
gmcnaugh
Hi,
I have an Excel work book which has a row of totals in cells which are
6 columns apart. Eg the 1st cell is K71, the next Q71 the next W71etc
etc up to a maximum of 25 cells. In another sheet within the same book
I have a totals sheet which I need to display the totals from the 1st
sheet. I have copied the 1st 2 references from the original sheet into
cells which are adjacent to each other in my totals sheet with the
intention of dragging and dropping for the next 23 or so cells hoping
that Excel would pick up on the fact that the referenced cells are 6
rows apart. But this does not happen. I have tried various methods
including OFFSET but still cannot acieve the desired result.
Any assistance with this will be gratefully received as I currently
have to copy each cell manually which is very boring and time
consuming.
I have an Excel work book which has a row of totals in cells which are
6 columns apart. Eg the 1st cell is K71, the next Q71 the next W71etc
etc up to a maximum of 25 cells. In another sheet within the same book
I have a totals sheet which I need to display the totals from the 1st
sheet. I have copied the 1st 2 references from the original sheet into
cells which are adjacent to each other in my totals sheet with the
intention of dragging and dropping for the next 23 or so cells hoping
that Excel would pick up on the fact that the referenced cells are 6
rows apart. But this does not happen. I have tried various methods
including OFFSET but still cannot acieve the desired result.
Any assistance with this will be gratefully received as I currently
have to copy each cell manually which is very boring and time
consuming.