<s>[INST] Give me the formula to grab data from an excel spreadsheet and use it in another. Take into account that the office version is 365. [/INST] The following formula will take the data from "Source.xlsx" in worksheet "Sheet1" columns A to C and rows 1 to 10:  

```
=[Source.xlsx]Sheet1!$A$1:$C$10
```

You can also generate similar code by typing an "`=`" into the formula bar of the destination spreadsheet and then selecting the relevent part of the source spreadsheet.</s>\ <s>[INST] Does that other file have to be in the same folder? How can I give an absolute path? [/INST] No, It doesn't have to be in the same folder, and yes you can use an absolute path.</s>