Hello,

Spreadsheet A gets figures from numerous other spreadsheets and
calculates a summary of the current months stats, the layout is like
this;

1--------WEEK 1--------WEEK 2---------WEEK 3---------WEEK 4--------WEEK
5-----------

2--------510847--------675676---------467575---------575664--------
346545 -----------



I have to send the relevant figure for last week in a spreadsheet B
every week. Is it possible to have a formula in spreadsheet B to
automatically find and show the figure for the previous week?

Note - the stats are gathered into weeks by the spreadsheet, so week 1
wont always start at the first of the month.


--
DKerr
------------------------------------------------------------------------
DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087
View this thread: http://www.excelforum.com/showthread...hreadid=572154