CrazyJ Wrote:
I want to get data out of an old spreadsheet. Each month I have to rank
the
sales performance of our territories. I rank them for four different
criteria which is easy enough, but then I need to compare this month's
ranking with last month's. Currently I am going back to the previous
month's
spreadsheet and finding the old ranking for each territory and copying
it
over to my new spreadsheet one by one which is quite tedious. I am
hoping to
find a way of automatically pulling that data out of the old
spreadsheet, any
suggestions?

Hi CrazyJ

Try using links, with both spreadseets open, click in a cell on the new
month spreadsheet where you want the previous months ranking, type =, go
to the previous months workbook and click on the cell containing the
relevant ranking and hit Enter


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=483949