Hi,

You can import the date from old workbook to the new one (Data - Import).
Or just type = in the cell and then select the value you want to use from
another workbook.

--
Best regards,
Peter Jaušovec
http://blog.jausovec.net
http://office.jausovec.net


"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?