Help creating a summary table

[Craig Thomson]

I have a worksheet with budget info that I want to summarise in
another table. The base data has monthly columns for actual, budget
and variance, e.g.:

Jan | | | Feb | |
Actual | Budget | Var | Actual | Budget | Var

etc

I would like to get a summary table of *just* the variance (var)
column, something like:

Jan | Feb | Mar
Var | Var | Var

etc

But when I do the Jan column and copy the Feb column the relative
reference also moves over, but only 1 column - so it then gets the
Actual column for the next month and not the variance. How can I get
it to move over 3 column each time?

TIA.

Craig

 

[Frank Kabel]

Hi
try the following formula in your summary table (assumption your
formula for January is in A2 and the data for your monthly data also
starts in A2)
=OFFSET('month_table'!$A$3,0,(COLUMN()-1)*3)
and copy to the right