Hi,

I am trying to use the offset function to pick out data from a seperate
worksheet. I use a variable in a cell that determines the location of
the relevent cells and found this works well.
My problem is that the offset function picks out the wrong data because
of some extra columns that I have, for instance......
If I decide that the relevent cells are 3 backwards from the offset
start point this works fine ....eg assuming the offset start point is
the 1 under april
Spreadsheet 1 Spreadsheet 2

Jan Feb Mar Apr ..... Reference 3 back gives
3 (under jan)
3 2 1 1

However by adding additional columns I do not pick up the information I
require... eg assuming the same case but in a different time
Spreadsheet 1

Nov Dec Year total BLANK COLUMN Jan Feb
3 2 15 2 3

Now assuming the start point of Feb (the 3) and going 3 cells back will
give the yearly total of 15 ... whereas I am actually after the 3 under
Nov.
I have been adjusting this so far by adjusting any offsets that cross
these blank columns and yearly totals but I would love to hear of a way
that can automate Excel so I do not need to trawl through the
calculations.

Any help would be much appreciated!!!
J


--
jagbabbra
------------------------------------------------------------------------
jagbabbra's Profile: http://www.excelforum.com/member.php...o&userid=32525
View this thread: http://www.excelforum.com/showthread...hreadid=545017