I have data in another workbook that I want to pull into my current workbook. How do I do this?
The easiest way to accomplish this is to open both workbooks. In the workbook you want to pull the data to, enter =, then go to the workbook you are pulling from and select the cell you would like to pull over.
Alternatively, you can simply type the formula which is:
=’[Source Workbook Name.xls]SheetName’!$A$1
You will get a message when you open your workbook stating that there is data linked ot other datasources. Be forewarned…Problems can (and often do) arise when you share your workbook with others. Remember that the linked datasource cannot be on your local system and if it is in a shared folder, they must have access to the shared folder as well.