Formula to Fill Down that picks up columns

[JamesKM]

I have a workbook set up as follows:

Sheet1:
Row 1: Month (Jan, Jan, Jan, Feb, Feb, Feb etc - 3 for each month)
Row 2: Budget, Actual, Difference, (repeated for each month)
Row3: contains a sum of the rows below for each of the budget, actual and difference.

Sheet2:
ColumnA: Title is Month, data is Jan, Feb, Mar etc
ColumnB: Tilte is Budget, data is to be Sheet1!B3, Sheet1!E3, Sheet1!H3 etc
ColumnC: Title is Actual, data is to be Sheet1!C3, Sheet1!F3, Sheet1!I3 etc

So, I would like to know if it possible to have a formula that specifies the row and adds 3 to the "Base" column each time that I can put in a fill down.

thanks in advance for any guidance,

James

 

[jimboy]

try using the offset function;

=OFFSET(Sheet1!$A$1,2,((ROW()-1)*3)-2)

This will work for row 3 but you will need to play around if the row if you want to return data from another row, post back if you are not sure.

 

[JamesKM]

Worked perfectly (with adjustment as you sugested - thanks very much

James