There maybe at times a necessity to link multiple sheets together in order to retrieve data. For example of this procedure follow these steps:
- Open up Excel and go to Sheet #3.
- In cell A1 enter 50.
- Then select Sheet #1.
- Then in cell A1, enter the formula =sheet3!a1 and hit the Enter key. The value should be 50.
Notice to link a sheet on a value, all you do is enter the sheet number separated by an exclamation point and then the cell where the data is you want to display.
Tip is from Sue Whitehouse and extracted from Tipworld, visit their website for more tips by clicking on the globe
Just click on the button for the Tiproom's Home Page.