how do I get data from one excel spreadsheet to another

[Guest]

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?

 

[Guest]

If your data is stored vertically on Both sheets,with a commone variable such
as Territory, or Sales person, you can do a V-lookup. I have these
instructions all typed up with some screen captures and I can e-mail them to
you.
My email address is : (e-mail address removed)
If you would like them, send me an e-mail to this address and I will forward
them to you. I use v-lookup almost daily. It's great for comparing what's
on one sheet and not on another, extracting information form one sheet into
another. It's too lenghty to explain here.

 

[Guest]

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.

 

[Paul Sheppard]

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