To copy information from a workbook to a worksheet in a different workbook
or in the same workbook, just a different worksheet:
Both the target and the source must be open. Should probably never work on one without the other open.
On target, click in the cell where you want the information, type =
Go to the source, click the cell you want, press enter
Go back to target - it should be there! However, to be able to fill down, change the row reference to relative instead of absolute (remove the $).
Then fill down.
Return to Teacher Help Pages or Student Resource Pages
Last updated June 23, 2011
~
Mrs. K. Bradley
kbradley@otsegoknights.org