Help..Getting data from another spreadsheet

C

cobra234111

Hi,
I am tring to put together a stats book.I have the data imported
through a query. However it's missing some important info so I went
to
another site a imported the other data into a differnt spreadsheet.
Now, is there a way to import data from one sheet to another. SAy I
have player A and I want to import his average. How do I do that?
Thanks for the help...
PS. Is there a way to sort data by the highest or lowest numeral entry
 
C

Charles T. Garrett

You can try this formula.

The formula is something like this =[88888888888]Sheet1!$C$9

888888888= the file name that holds the wanted information
Cell name that holds the information = $C$9

OR

Open both sheets. Click in the cell when you want the information put,
press "equals sign".
Now go to the other sheet and click the cell that holds the information you
want to copy into the new sheet, and click enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups - how to obtain data from a master spreadsheet into another 5
Importing data from another worksheet in the same spreadsheet 5
Question Regarding Auto-Sorting Data 2
Importing data from XML 2
Excel 2007 -> Filtered Data Connection from Another Spreadsheet 6
Tranfering data from one spreadsheet to another Automatically 2
Is it possible to have an image as a background? 0
Match data from columns 1

Top