You have huge amount of data separated in different Excel files. You want to manipulate with the data by coming up with equations. The question is: Is it possible to link 2 or more Excel files in one equation? Yes it is. If you can link Excel sheets, you can also do it with the files.
You could do it by creating links between cells in the two files. Here is the step by step procedure on how to do it:
- Open both workbooks
- Activate the workbook you want automatically updated ie. the one that will not be edited by the operator
- Select a cell you want to link
- Type =
- Activate the other workbook
- Select the cell you want to link and hit "enter"
- You will return to the first workbook and the selected cell will contain the reference e.g. =[FirstBook.xls]Sheet1!$A$11
- Repeat for each cell you want to link
- If you want to, you could include references in formulae, say if you wanted half the value, you would do as above then add /2 to get =[FirstBook.xls]Sheet1!$A$11/2
or maybe multiply the vales of two cells e.g.
=[FirstBook.xls]Sheet1!$A$11* =[FirstBook.xls]Sheet1!$B$42
Recent Posts
Popular Posts
- Convert UTM (Easting, Northing) to Lat-Long Formats
- GIS Education Submission
- GRASS GIS Free Tutorial
- Mobile Cadastral GIS 3.0 Android App Released in Taiwan
- Free download Worldview-1 imagery / QuickBird satellite images
- Learn ENVI software online - Tutorial guide
- Free Download S-PLUS software Student Edition
- ENVI Band Math Tutorial, Help Guide
- Valtus Imagery Services
- Free SPOT Images now in USGS Archive
0 comments:
Post a Comment