Linking Spreadsheets

There maybe at times a necessity to link multiple sheets together in order to retrieve data. For example of this procedure follow these steps:

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 globe
home button   Just click on the button for the Tiproom's Home Page.