copying formula across help!

[markster]

Happy Xmas guys
I have 2 spreadsheets A & B

Spreadsheet A is a summary of information on Spreadsheet B up to 2009. Basically when I link from Spreadsheet A to cell (B4) to I4 on Spreadsheet then I need to copy across to pick up each months totals until 2009. The only problem is that I need it to copy across every 8th cell (just the totals of each month) not every cell. Don't have a clue how to do this.
Not sure whether this will make sense to you. Example spreadsheet attached.

Book2
	A	B	C	D	E	F	G	H	I
1	Spreadsheet A (Summary)
2
3	Division	Apr-07	May-07	Jun-07
4	HR	1.00	0.00	0.00
5	Production	3.00	0.00	0.00
6	Finance	4.00	0.00	0.00
7
8	Spreadsheet B
9
10		Apr-07
11	Division	Work Level	Manager	Supervisor	Admin 1	Admin 2	Admin 3	Total Admin	Total
12	HR	0	1.00	0.00	0.00	0.00	0.00	0.00	1.00
13	Production	0	2.00	1.00	0.00	0.00	0.00	0.00	3.00
14	Finance	0	2.00	1.00	1.00	0.00	0.00	0.00	4.00
15
Sheet1

 

[erik.van.geit]

Hello, markster,

try something like this

=INDIRECT("B!" & ADDRESS(ROW(),(COLUMN()-1)*8+1))

supposing your formulas are on spreadsheet A starting in column B
on spreadsheet B you have totals in columns I, Q, Y (9, 17, 25)

kind regards,
Erik