Adding 8 columns by formula

  • Thread starter Thread starter Rivers
  • Start date Start date
R

Rivers

hi all is this possible.

i have in the background a spreadsheet that everyweek i add seven columns
and an 8 column that sums the seven days. simple enough! now i have a front
sheet that collates the back sheet by bringing forward the sum columns and
collates them by row ie A6 = backsheet!AB7 A7=backsheet!Aj7

instead of everyweek having to create the equals signs i just want to put in
a formula that simply goes down the rows adding 8 columns to the previous row
for 52 weeks.


something like this =backsheet!column(a3+6)

is this possible? i dont mind adding an extra column in my front row to
hold/store numbers as i think this is whats going to be needed to make this
work.

thanks before hand


Rivers
 
Back
Top