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