copying formula across help!

markster

Active Member
Joined
May 23, 2002
Messages
487
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
ABCDEFGHI
1Spreadsheet A (Summary)
2
3DivisionApr-07May-07Jun-07
4HR1.000.000.00
5Production3.000.000.00
6Finance4.000.000.00
7
8Spreadsheet B
9
10Apr-07
11DivisionWork LevelManagerSupervisorAdmin 1Admin 2Admin 3Total AdminTotal
12HR01.000.000.000.000.000.001.00
13Production02.001.000.000.000.000.003.00
14Finance02.001.001.000.000.000.004.00
15
Sheet1
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, markster,

try something like this
Code:
=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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,071
Messages
5,570,023
Members
412,304
Latest member
citrus
Top