Help..Getting data from another spreadsheet

  • Thread starter Thread starter cobra234111
  • Start date Start date
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
 
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.
 
Back
Top