Linking Information from one Worksheet to another:

Use the instructions below to reference cell information from one worksheet to another worksheet. What do I mean?

For example, you want a time and attendance workbook to automate your leave time at your organization. You decide to have a separate sheet for each month: January – December. This will give you 12 worksheets plus the “Summary” page where all the information posts back. The Summary sheet will enable you to quickly view all the days you were absent, used vacation or personal days.

1. Open your workbook with multiple worksheets, and locate the cell you want to have on another worksheet. For this example, we will say AH10.
2. RIGHT mouse click on the cell and select Copy.
3. Now click on the sheet you want to copy that cell information into.
4. Locate a cell that you want the copy the information from the first worksheet (AH10) and RIGHT mouse click.
5. Select Paste Special and a window box will appear.
6. Decide on which options you want to choose, and select Paste Link. This will create a bridge or “link” to that information.

As the information in the one cell changes, it posts back or update the summary page.